Duplicate a chart with relative formulas

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?
 
J

Jon Peltier

Duplicate the sheet that has the chart, then replace the data on the
copied sheet.

- Jon
 
Top