Thread: How do I stop charts updating when I reorder the data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme[_3_] Bernard Liengme[_3_] is offline
external usenet poster
  
Posts: 1,104
Default 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.


Reply With QuoteReply With Quote