CODEWITHSUNDEEP
excelvbauser-interfacechartsuser-experience
AnthonyT
AnthonyT

Reputation: 536

VBA Prevent Charts from AutoUpdating in Excel

I have a button to import data into my spreadsheet. I ported the calculated values for visuals outside of the dashboard range and plotted charts linking to those values. Whenever I import new data, those values change instantly as well as the charts. Is it possible to prevent the charts from automatically updating, and move that command to a macro?

Thanks,

Upvotes: 0

Views: 1861

Answers (1)

Andy Wynn
Andy Wynn

Reputation: 1256

There is no way to delay/defer updating the visuals of a chart, even if you disable calculation, the charts will refresh when its data source refreshes, but you could point your charts to a data source on a hidden sheet, and use a macro to update the values there when a button is clicked.

Let me know in the comments if you get stuck doing this, or if this is not satisfactory.

Upvotes: 3

Related Questions