Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Graph links to copied sheet
Hi
I have noticed a difference between Office 2003 and 2007. In 2007 when you copy a sheet with graphs in it, the new sheet keeps the links to the table in the original sheet not the copied one. So when you input new values on the new table the graph does not show them, but the old ones. Does anyone know how to change settings so the new graph has the links to the new table/sheet? Many thanks PS Also, anyone knows how to eliminate some sections of the ribbons? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Graph links to copied sheet
Miguel -
I think this discrepancy existed in early versions of 2007, but in SP2, and I think SP1, a chart on a copied sheet links to the data on the copied sheet, not to the original data. If it's a pivot chart on a worksheet, the copied pivot chart still links to the original pivot table, in 2007 and in 2003. But remember, pivot charts aren't *real* charts ;-) - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Miguel M" <Miguel M @discussions.microsoft.com wrote in message ... Hi I have noticed a difference between Office 2003 and 2007. In 2007 when you copy a sheet with graphs in it, the new sheet keeps the links to the table in the original sheet not the copied one. So when you input new values on the new table the graph does not show them, but the old ones. Does anyone know how to change settings so the new graph has the links to the new table/sheet? Many thanks PS Also, anyone knows how to eliminate some sections of the ribbons? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copied Graph changes values | Charts and Charting in Excel | |||
how to unlink links copied from a list from the internet | Excel Discussion (Misc queries) | |||
Word O7 looses links with excel 07 when files copied to network fr | Links and Linking in Excel | |||
Bug: Move or Copy sheet graph links not updating! | Excel Discussion (Misc queries) | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |