Refreshing charts
 

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

Refreshing charts
 

CTRL+ALT+F9

will cause a full recalculation.

--
Regards,
Tom Ogilvy

"Roger" wrote in message
...
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

Refreshing charts
 

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?



-----Original Message-----
CTRL+ALT+F9

will cause a full recalculation.

--
Regards,
Tom Ogilvy

"Roger" wrote in
message
...
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


.

Refreshing charts
 

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

"rog" wrote in message
...
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?



-----Original Message-----
CTRL+ALT+F9

will cause a full recalculation.

--
Regards,
Tom Ogilvy

"Roger" wrote in
message
...
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


.

Refreshing charts
 

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

"rog" wrote in
message
...
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?



-----Original Message-----
CTRL+ALT+F9

will cause a full recalculation.

--
Regards,
Tom Ogilvy

"Roger" wrote in
message
...
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


.



.