Issue #1: Copying Charts without bringin source sheet reference

[bhujanga]

The first issue I have is that when I copy an entire worksheet which includes multiple charts, all of the charts keep the reference to the origin sheet in their data definitions. This makes me blue because I just want to be able to paste new data into the new sheets and be done! But instead I must go through and tweak all of the various data sources for all of the charts and in this situation that is a time consuming proposition. I could swear that I have been able to do this before without even trying but cannot figure out how to do it now. Is there a certain way to do the copying that will achieve this?

 

[SkipVought]

Hi,

Why don't you do the reassignment of chart source data programmatically?

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]