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