Help with Charting

I am looking to make my excel spreadsheets into charts that I can overlay to see different correlations. I want to be able to easily change the date or other information. I am not sure if there is a way to do this easily or not. What I am envisioning in my head in transparencies that I can lay down over the top of each other but that I can change in real-time. If this doesn't make sense, I can try to explain it better.

I have also added an attachment with some dummy data to help understand what I am looking to chart. If more data is needed, I can put more in.