Copying charts to other worksheets

[Dave R.]

Is there a way to copy a chart to another worksheet within a workbook, and
have it change the worksheet referenced in the source data? I am asking this
because I have 7 sheets setup exactly the same way, and need graphs for
each, but would like to avoid having to reassign the ranges for each sheet.

 

[Jon Peltier]

Dave -

This is the easiest way: make copies of your sheet with the chart (the
chart on the copied sheet will refer to the data on the copied sheet),
then copy the new data, and use Paste Special from the Edit menu, and
use the Values option.

- Jon

 

[Dave R.]

Thanks Jon, that worked and saved me some time! I used regular paste and it
worked as far as I can see.
Dave