Macro to Update Charts Source Data
 

All,
I have 50 sheets containing data... I want to create the same set of
charts referencing each of these sheets. I was searching the groups
and found the following link:
http://www.peltiertech.com/Excel/Charts/ChgSrsFmla.html


I tried to run each of the example macros, but with no success. Each
time I get the error:


Run-time error '1004':
Unable to get the Formula property of the Series class


When I click on Debug it takes me to the following line of code:
mySrs.Formula = WorksheetFunction.Substitute(mySrs.Formula, strFrom,
strTo)


Can anyone give me some insight as to why this is happening? I'm
relatively new to Macros in Excel, so thanks for your patience. ;0)


Thanks,
Mary

Macro to Update Charts Source Data
 

Are the charts on each worksheet with the data? It's probably easier if the sheets
have the same structure to make copies of a sheet with properly linked charts, then
copying the data and pasting special as values in the copied sheet.

Regarding the Change Series Formula macro, what do your chart series look like
before changing and what should they look like after changing?

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

wrote:

All,
I have 50 sheets containing data... I want to create the same set of
charts referencing each of these sheets. I was searching the groups
and found the following link:
http://www.peltiertech.com/Excel/Charts/ChgSrsFmla.html


I tried to run each of the example macros, but with no success. Each
time I get the error:


Run-time error '1004':
Unable to get the Formula property of the Series class


When I click on Debug it takes me to the following line of code:
mySrs.Formula = WorksheetFunction.Substitute(mySrs.Formula, strFrom,
strTo)


Can anyone give me some insight as to why this is happening? I'm
relatively new to Macros in Excel, so thanks for your patience. ;0)


Thanks,
Mary