Chart Data
 

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.

Chart Data
 

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

--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"joey3" wrote in message
...
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.