Automatic updating charts in excel 2016
' Force the charts to update Set sht = Active Sheet For Each co In sht. I found that if I went back into the "Select Data Source" msg box and unchecked/rechecked the "show data hidden in rows and columns" that the chart refreshes. After that, using radio buttons to select data to be presented on graphs did not update the graphs anymore. It then asked me to change a value and watch the percentage change, then to look at the pie chart and see the update. I looked at the data source for the pie chart, and the range was bizarre. If I closed everything and opened just the file I was having problems with the charts where dynamic like they should be. Be sure you are copying and pasting pictures before you go through all the other motions.... If it's a named range, that could conceivably be reasonably clean. My solution has been to make all charts on the active sheet invisible before the change in data, then make them visible again and call chart refresh for good measure. I change a cell value which contains, for example, the date range to base the dashboard on, and the named ranges and UDFs are forced to calculate.
To set this up: The final way to update the pivot table is with programming.
In the demo below, Peter Kalmström, CEO and Systems Designer of Business Solutions, shows how to use the Excel Web Access web part.