Duplicate a chart with relative formulas

  • Thread starter Thread starter Bobhoe
  • Start date Start date
B

Bobhoe

If I have several sheets, each with data for a particular year, how can I
copy a chart from 1 year to all the others, making sure the data references
are to the respective year?
 
Duplicate the sheet that has the chart, then replace the data on the
copied sheet.

- Jon
 
Back
Top