View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Updating Charts in Excel 2007

Something is wrong; this is not how XL 2007 works.
Click on the chart and look in the formula bar.
You should see something in the form:
=SERIES(Sheet2!$E$17,Sheet2!$D$18:$D$22,Sheet2!$E$ 18:$E$22,1)
What do you see?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"dmrs" wrote in message
...
I have created a scatter diagram chart in Excel 2007. When I overwrite the
source data, populating the cells with new data, the chart does not
update.
I have found the only way to change the chart is to delete all data series
and re-create them. Is there a better way?
--
dmrs