Excel Chart Source Data

[dilworth]

Is it possible to update Excel Chart Source Data for Multiple Chart
where the ranges are exactly the same?

We have a large workbook containing 25 worksheets with charts that ar
linked to another Master Workbook.
The charts display data for a rolling 12 month timescale and so th
source data needs to be manually updated each month to reflect th
current rolling 12 month timescale e.g

May 2003 to April 2004 cell range A1:Z1 would need to be updated t
reflect June 2003 to May 2004 to B1:AA1

There are 100 charts so manually updating the Source Data is tim
consuming-as the cell references are the same for all charts is i
possible to update the source data in bulk in similar way to the Fin
and Replace funcion?

Any help is appreciated

 

[Jon Peltier]

The charts should be set up using dynamic ranges for the series source
data. It will be a lot of work the first time you do it, then it will
update automatically each successive month. Here are some examples and
links to many more examples:

http://peltiertech.com/Excel/Charts/Dynamics.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______