If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I stop charts updating when I reorder the data
I have tried with Excel 2003 and I can start an XY chart and then change the
order of the data by sorting to put it into a different chart without it changing the chart. with 2007 this does not appear to happen and my original chart changes. |
#2
|
|||
|
|||
How do I stop charts updating when I reorder the data
I would expect an XY chart in any version of Excel to alter when the data is
reorder best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "j99harrison" wrote in message ... I have tried with Excel 2003 and I can start an XY chart and then change the order of the data by sorting to put it into a different chart without it changing the chart. with 2007 this does not appear to happen and my original chart changes. |
Thread Tools | |
Display Modes | |
|
|