Excel won't recalculate in graphs

R

Roger Nye

Hi, I have some data displayed in a chart or graph and when the numbers
recalculate, the graph stays the same.

I have checked the chart reference and it is clearly pointing to the data
that changed.
I tried editing the chart reference, without changing it, but it isn't fooled.
I tried hitting F9, switching calculation mode to manual and back.

The only way I can get it to change the graph is to delete the series and
putting it in again every time.

Any suggestions?
Thanks
 

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

Create a chart from a table in word thats dynamic 0
Two graphs, primary/secondary y-axis with log x-axis 0
Advice on simple graphs with Excel 2010 4
Macro to Create Hundreds of Graphs 7
Automatic Macro to create 200 graphs 1
Compressing graphs from excel into word 0
Excel macros graphs work on one laptop, but do not on another. Wh 1
Graph to display Range Label and Mean 0

Top