D
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
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