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


Jason Wicks wrote:
> 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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html