How to stop Excel from auto updating chart?

  • Thread starter Thread starter P. Lui
  • Start date Start date
P

P. Lui

Hi,

I have written a VBA that will find some averages for me. It'll
output the averages in the same range of cells no matter which
monthly/seasonal averages I wanted. Is there a way to make the chart
so that let's say...after I run the script to calculate the winter
averages, then make a chart of it on a worksheet, when I re-run the
script for summer, the chart wouldn't update to the summer data? In
another word, can I have the chart to not update? I know under
there's Tools->Option->Edit->Ask to update automatic links but I don't
think this is what I'm looking for as it's already checked.

Thanks.
 
Back
Top