Forum Discussion
Setting graph colours to results.
I have created a log with a second sheet displaying MI in pivot tables and charts all linked to a few slicers. The pivots are all set to not store the data.
Everything is how I want it with a stack...
Hello,
pivot charts have a reputation of weird behaviour, especially when the data is removed and then re-added. You could try playing with the setting for charts in File > Options > Advanced. See if toggling the tick boxes highlighted in the screenshots make a difference. Note that this setting is saved with the workbook, not for Excel overall.