Range Calculate to update chart

  • Thread starter Thread starter Ben
  • Start date Start date
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
 
Back
Top