Automatic updating graphs in excel
Thank you I have run into this same issue - not sure why, and when it happens the only way I have ever gotten the chart to force update is to change something in the chart definition itself, which can easily be done via VBA as in: There may be a better answer that gets to the bottom of the problem - but I thought this might help. Formula = temp Next sc Next co This is an absurd bug that is severely hampering my work with Excel. It happens to be a problem of refreshing the generated charts. This works for me and also handles similar issues with charts as well as chart objects. And by the way, these are chart objects, not chart sheets. I was dynamically building a querydef, setting that as the rowsource on my report and then trying to loop through each series and set the properties of each series.
Working on the sheet I would do a quick Ctrl-X, Ctrl-V on a piece of the chart (or the whole thing) to force the chart to update. Based on the work arounds posted I came to the following actions as the simplist way to move forward... When I zoom in or zoom out, I can get the expected results. The refresh may not be necessary - more testing needed. Anyway, let's cut to the solution: I didn't want to visibly change the chart title or some other aspect of it, and anyway I noticed this wasn't updating my charts consistently. Screen Updating = True End Sub So, the sheet named Charts Data, which references the custom function cell of Sheet 1, will do a recalculation AFTER the Compute Score() function has updated the cell of Sheet 1, since Worksheet_Calculate() fires after the Compute Score() recalc. Select 'Forwhatever reason a Select statement was needed . What I eventually had to do was to break out the querydef creation and the property setting into separate subs.
Messing with vb doesn't seem like a durable solution to me (other people are sometimes affected in my company on different files).
I am really curious about what is the source of this to be honest.
Edit : I just created another chart in the same worksheet from this: 1, 2 and 01/02, 01/03 So 1 and 2 is the source data and the dates are the x axis. The quickest way I seem to have for getting a refreshed chart is to cut and paste back the chart.
In addition to the data, some cells to the left and on top are reserved for category and series labels.
We all know that to make a chart we must specify a range of values as input.
But what if our range is dynamic and keeps on growing or shrinking.
Every time I want to see an updated version of it I have to either delete the serie and add it again or re-open the file.
Another colleague came up with the same issue on a completely different computer/file/data/chart.
If Power Point is not yet running, it starts automatically.