View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Miguel M Miguel M is offline
external usenet poster
 
Posts: 1
Default 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?