ExcelBanter - Duplicate a chart with relative formulas

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Duplicate a chart with relative formulas (https://www.excelbanter.com/charts-charting-excel/259727-duplicate-chart-relative-formulas.html)

Bobhoe

Duplicate a chart with relative formulas

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?

Jon Peltier[_2_]

Duplicate a chart with relative formulas

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?

All times are GMT +1. The time now is 05:05 PM.