Chart Data

[Guest]

Hi,
In 2003 Excel, you can copy your chart to another sheet within a workbook
and edit the data. The new graph will reflect the new data of the new sheet.
In 2007 Excel, when you copy the chart, it will still reference to the
original data_ you'll have a graph that doesn't match your valueso on the
same sheet. Please help.

 

[Bernard Liengme]

In XL2003 you need to edit data as you state.
In XL2007 the same applies; right click chart, use the Select Data item on
popup menu to set new data range
best wishes