From: Bobhoe on
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?
From: Jon Peltier on
Duplicate the sheet that has the chart, then replace the data on the
copied sheet.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 3/23/2010 9:29 PM, Bobhoe wrote:
> 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?