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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart data references not changing to new tab when worksheet is co
This is a problem with Excel 2007. I think if you copy the sheet to a new
workbook, then copy it back into the original workbook, your linkage will be maintained. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Marsdrummer" wrote in message ... 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? |
Reply |
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 |