| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart data references not changing to new tab when worksheet is co
I've been on Excel 2007 for two months and I have a recurring problem with
worksheets I coded in Excel 2003. When I copy a worksheet that contains a chart, the new chart still retrieves its data from cells on the original sheet. I am trying to create one sheet as a template, then copy it multiple times, and change the data (and graphs) on each new sheet. Obviously I want the charts to get the data from the sheets they are on, not the original sheet. Am I doing something wrong? Is there a way to fix this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a chart that displays two cell references as one data po. | Charts and Charting in Excel | |||
| Excel Chart-data references link another worksheet in same workboo | Excel Discussion (Misc queries) | |||
| I want chart source data to be relative references, not absolute. | Charts and Charting in Excel | |||
| Changing Cell References To a Different Worksheet in the Same Cell | Excel Worksheet Functions | |||
| How can I paste a formula that references a chart of data | Excel Worksheet Functions | |||
Threaded Mode
