| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying formulas with relative references | Excel Discussion (Misc queries) | |||
| Changing formulas from relative to absolute | Excel Discussion (Misc queries) | |||
| Confused about relative references in named formulas | Excel Worksheet Functions | |||
| Relative column referencing within formulas | Excel Discussion (Misc queries) | |||
| Relative worksheet reference in 3-D formulas? | Excel Worksheet Functions | |||
![Jon Peltier[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
