Excel 2016 chart not updating
fill colours, border colours) and changing them back to automatic. change the cell range that a series refers to), the fill and border options lose the specified formatting and go back to automatic.This is problematic because I like to create one master chart which is formatted exactly how I like it, then copy this chart several times so that I can re-use it with different underlying data.If you want to learn more about data visualizations that don’t suck, check out my Annielytics Dashboard Course offerings.
Once the workbook is saved with the newer Excel version, a single recalculation suffices.
Normally, if I change a value that a bar graph uses I see the bar graph change - but that does not happen with the cells that have values placed in them by the macro.
I also have a section that sums the values in the chart to make sure it's running right, and these values do not update automatically as well.
You can the options in the drop-down filter and even select them.
In fact, the pivot table (that’s created with every pivot chart) updates. I demonstrate this disappointing failure in this short demo. Go ahead and test it for yourself with the pivot chart in this Excel file.