I have 25 worksheets each with 2 graphs.
I need to revise the source series for all the graphs in these worksheets.

I thought I can use VB language to auto change the series reference
but I do not know the index number for each of the chart

"ActiveSheet.ChartObjects("index").Activate

Hope I could have advice on how to activate each charts without useing the
chart index

--
Thanks a million for your time and expert advice :-)
Jaylin
*****Jaylin Message ended*******