Updating Charts in Excel 2007

G

Guest

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?
 
B

Bernard Liengme

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
 
K

Kate

I am having this same problem. Yes I do see something of the form
=SERIES(blah blah) in the formula bar.
Why doesn't the chart update? It just tells me I have invalid
references...
Cheers
Kate
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 Charts and Call Outs 2
Excel 2007: continuously update scatter chart from scroll bars 1
Can't drag new data to chart in 2007. 1
Excel 2007 XY Scatter Chart 2
3-axis charts 6
Charts disabled in Excel 2007 ribbon 2
Pivot Charts 3
XY Scatter Pivot Chart in Excel 2000 2

Top