REVscene Automotive Forum - View Single Post

shenmecar · 08-02-2011, 10:09 AM

I'm planning to create a chart in excel 07 for cost analysis of 10 items for school. Cost on Y-Axis and Time on X-Axis. So the chart will be Cost vs Time.

Its not very neat to the eye to have all 10 items on the same chart. So, what I was thinking to do was create individual charts for the items. This I know how to do.

Then create one blank chart, with two drop down list, that can bring up any
two individual charts so I can compare the chosen two charts overlaid on top of each other.

Any one know how to do this?

08-02-2011, 10:09 AM	#1
shenmecar RS.net, helping ugly ppl have sex since 2001 Join Date: Sep 2008 Location: Vancouver Posts: 8,858 Thanked 2,420 Times in 669 Posts Failed 530 Times in 136 Posts	Excel Gurus I need help I'm planning to create a chart in excel 07 for cost analysis of 10 items for school. Cost on Y-Axis and Time on X-Axis. So the chart will be Cost vs Time. Its not very neat to the eye to have all 10 items on the same chart. So, what I was thinking to do was create individual charts for the items. This I know how to do. Then create one blank chart, with two drop down list, that can bring up any two individual charts so I can compare the chosen two charts overlaid on top of each other. Any one know how to do this? __________________ 2014 Honda Civic Si Last edited by shenmecar; 08-02-2011 at 10:24 AM.