Refreshing charts

[Roger]

XL97

Calculation set to manual

If I calculate the range that is the source data to a
chart, is there some way I can then refresh that chart?

Thanks

Rog

 

[Tom Ogilvy]

CTRL+ALT+F9

will cause a full recalculation.

 

[rog]

Thanks Tom, but I am recalculating the source range using
code, and I don't want to recalc the whole workbook as it
takes too long

Any more ideas just to refresh the chart?

 

[Tom Ogilvy]

Not something I have had a need to do, but I would try looping through the
seriescollection and for each series, set the formula to itself.

 

[Rog]

That will do nicely thanks Tom

-----Original Message-----
Not something I have had a need to do, but I would try looping through the
seriescollection and for each series, set the formula to itself.

--
Regards,
Tom Ogilvy




.