Excel 2003 Charts won't update

N

niceguyneedshelp

Problem:
When typing in new data into a set of data withing a charts data source, the
chart will not update until I close and re-open the file.

Background:
1) This is not attached to a pivot table.
2) The data is directly typed over and it is within the charts data source
that is selected.

Any ideas why this is happening and what I can do?
 
J

John Mansfield

One possibility - go to Tools -> Options -> Calculation. If it is set on
manual you will need to set it to automatic.
 

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

refreshing charts 3
charts and pivot tables 2
Multiple Charts-Multiple Tabs 1
Odd Chart Format Results 1
Macro to update Chart 1
Pivot charts & tables 13
Set uniform scaling for same type of Pivot charts with varying dat 1
Pivot Tables to Charts 2

Top