Thread: Duplicate a chart with relative formulas
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier[_2_] Jon Peltier[_2_] is offline
external usenet poster
  
Posts: 461
Default 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?
Reply With QuoteReply With Quote