Change a Chart Datasource

[Jason Wicks]

Through VBA I have copy a chart from one sheet to another but the data
source still refers to the first. How can I change this to the new sheet
data source if this is also present? Assistance required. Thank you for your
consideration.

 

[Debra Dalgleish]

You can use a macro to change the series formulas. Jon Peltier has
instructions, and a sample workbook, on his web site:

http://www.peltiertech.com/Excel/Charts/ChgSrsFmla.html