Chart Question

[ICU]

I'm new to Excel and I'm working on a large dashboard. I have a summary sheet and 22 drilldown sheets. Each drilldown sheet is identical except for the data itself. So, I've been able to copy the sheets and change the data. Then data feeds back and forth automatically to and from the summary sheet.

I want to add a chart on each page showing the trend data agains the benchmarks. I've been able to do this by hand, but it's going to take a long time to do all 22 charts and enter all the data sets. Each chart is identical as well, is there a way to design one and copy it to each sheet so that it pulls the data from that sheet (the cell locations are the same on each sheet). Currently, the data sets include the sheet name, so if I copy and paste the chart, it pulls the same data on each sheet.

Make sense?
Bryan

 

[Steeviee]

In the copy version, right click the chart & choose Source data. If you have something in the data range field change the sheet name on there. if not, you'll have to go into the series tab & click on each series, changing the values field each time to the new sheet. I don't think that you can do this automatically (although if there is a way, someone on this board will know!)

If you haven't put too much work into creating all the sheets, the best way is to create the fist one including the graph and then when you copy the sheet, the new sheet will have it's own graph reading data from that sheet. make sense?