| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| refreshing charts | Charts and Charting in Excel | |||
| Pivot Charts - refreshing clears my chart formatting | Charts and Charting in Excel | |||
| How can I stop charts from refreshing when changing source data? | Charts and Charting in Excel | |||
| Refreshing several pivot charts with one move | Charts and Charting in Excel | |||
| refreshing charts | Charts and Charting in Excel | |||
![Roger[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
