Chart Data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

joey3 - 31 Aug 2007 01:20 GMT

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.

Reply to this Message

Bernard Liengme - 31 Aug 2007 15:53 GMT

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

Signature

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

> Hi,
> In 2003 Excel, you can copy your chart to another sheet within a workbook
[quoted text clipped - 3 lines]
> original data_ you'll have a graph that doesn't match your valueso on the
> same sheet. Please help.

Reply to this Message

Rate this thread: