Excel Charts do not update when workbook recalculated

[duane]

This is a repost as previous post got no replies

I have several good size excel workbooks with 30-40 charts with 5-1
series per chart which do not update when the workbook is recalculated
I have written a macro to select each series in each chart and redefin
the x axis values (but not changing it - and all x axis are the same)
rather brute force as you will see - so that the charts can be easil
ensured to be updated. Is there an easier fix than this? We are runnin
excel 2003.

rather than 100's of lines of code like the following, can this be don
via something like

for each chart....
for each series....

ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.ChartArea.Select
ActiveChart.SeriesCollection(1).XValues = "='Weekly Data'!R1C3:R1C94"
ActiveChart.SeriesCollection(2).XValues = "='Weekly Data'!R1C3:R1C94"

once is was set up it ran fine, but adding a chart or series was
pain.

thanks in advance....

 

[SteveG]

Check out Jon Peltier's site. I have used it several times with great
success.

Cheers,

Steve

http://peltiertech.com/Excel/Charts