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.
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.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks