| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I keep chart/data link when copying worksheet
I have a worksheet for each month within a file - each worksheet has data
tables, and some charts generated from that data. With Excel 2003, when I copied a worksheet within the same file (for example, to create the July sheet, by copying the June sheet) the charts in the new (copied) July sheet correctly linked to the July data. When I do the same in Excel 2007, the charts in the July sheet link back to the June data instead. I have looked through the options and cannot see how to do this. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying a chart and data to existing worksheet | Charts and Charting in Excel | |||
| Copying a Formula which contains a link to another worksheet | Excel Discussion (Misc queries) | |||
| How To: Link worksheet data to pre-existing chart tables | Excel Discussion (Misc queries) | |||
| How To: Link worksheet data to pre-existing chart tables | Excel Worksheet Functions | |||
| How To: Link worksheet data to pre-existing chart tables | Charts and Charting in Excel | |||
Threaded Mode
