Copying charts to other worksheets

  • Thread starter Thread starter Dave R.
  • Start date Start date
D

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.
 
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
 
Thanks Jon, that worked and saved me some time! I used regular paste and it
worked as far as I can see.
Dave
 
Back
Top