Refreshing charts

  • Thread starter Thread starter Roger
  • Start date Start date
R

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
 
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?
 
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.
 
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




.
Click to expand...
 
Back
Top