Macro to Update Charts
 

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