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?

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?