Making Chart Series Dynamic

[Cpinhey]

I am looking for a quick way to create a number charts using data from multiple sheets.

I have 12 sheets Apr - Mar that contain data in identical format. I also have sheets 12 sheets Apr Charts - Mar Charts, I need to create a number of charts on each sheet for the relevant month. To avoid having to create a ridiculous number of charts, I thought I would try to dynamically change the chart data series based on a value in say cell A1.

For example if cell A1 of the Apr Charts sheet = Apr, the chart will show the data for Apr.

The idea is that I can copy the Apr Charts sheet the required number of times and replace the value in A1, and my charts will update dynamically. I need to have seperate sheets for each of the monthly charts.

I'm not sure how to proceed, this is beyond my excel skill set - I'm guessing a named range, possible Offset or Indirect functions will be required.

Any help that can be offered will be greatly appreciated and will save me an immense amount of time. Thanks in advance.

 

[mathchick]

I am looking for a quick way to create a number charts using data from multiple sheets.

I have 12 sheets Apr - Mar that contain data in identical format. I also have sheets 12 sheets Apr Charts - Mar Charts, I need to create a number of charts on each sheet for the relevant month. To avoid having to create a ridiculous number of charts, I thought I would try to dynamically change the chart data series based on a value in say cell A1.

For example if cell A1 of the Apr Charts sheet = Apr, the chart will show the data for Apr.

The idea is that I can copy the Apr Charts sheet the required number of times and replace the value in A1, and my charts will update dynamically. I need to have seperate sheets for each of the monthly charts.

I'm not sure how to proceed, this is beyond my excel skill set - I'm guessing a named range, possible Offset or Indirect functions will be required.

Any help that can be offered will be greatly appreciated and will save me an immense amount of time. Thanks in advance.

It's hard to say without seeing what form the data it's pulling from is in, but vlookup and/or hlookup based on the month may suit your needs and would result in a far less-sluggish of a workbook then using offset and indirect.