Range Calculate to update chart

B

Ben

Hi

I have a chart that is on the same worksheet as its source data. I have a
button to recalculate the source data using the Range.Calculate function.
The only problem is, the chart does not get updated when the source data is
recalculated. I have tried call Chart.Refresh on the chart, but it has no
effect. The only way I have found to update the chart is to do a manual
calculation (F9), which is far too slow due to the size of the workbook. It
would be far better is the recalculate button updated the chart also. Any
ideas?

TIA
Ben
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel charts do not update when using SendKeys 8
Chart not updating with changes in source data 3
EXCEL 2007 CHART REFRESH WHILE MACRO IS RUNNING 2
Macro to update Chart 1
Table within a chart 4
Static Chart Data Range 2
Real-time update of chart using a Spin Button 4
Hide data labels with "0" values 3

Top