Excel Charts do not update when workbook recalculated
 

This is a repost as previous post got no replies

I have several good size excel workbooks with 30-40 charts with 5-10
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 redefine
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 easily
ensured to be updated. Is there an easier fix than this? We are running
excel 2003.

rather than 100's of lines of code like the following, can this be done
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 a
pain.

thanks in advance.....


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=496631

Excel Charts do not update when workbook recalculated
 

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

Cheers,

Steve

http://peltiertech.com/Excel/Charts


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=496631