By forcing the chart to re-evaluate the series, we are clearing the cache.'Refresh all charts For Each mysheet In Active Workbook.
Click on the graph you want update - Select CTRL-X, CTRL-V to cut and paste the graph in place...
However, the pie charts do not update--for some reason, other types of charts do.
XValues = "=tbl Ref[Secs]" End With End Sub My two cents for this problem--I was having a similar issue with a chart on an Access 2010 report.
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.