Graph links to copied sheet

[Miguel M]

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?

 

[Jon Peltier]

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