Forum Discussion
Solved
How can I stop Excel from changing the colors of my chart ?
I have a chart with past and forecasted figures for several series of data. I set the colors of each serie in order to have something nice and meaningful : 1 color per serie, dotted for forecast. E...
File > Options > Advanced > Chart >
deselect 'Properties follow chart data point for current workbook'
deselect 'Properties follow chart data point for all new workbooks'
Hello,
if this is a pivot chart, take a look at Jon Peltier's article Pivot Chart Formatting Changes When Filtered It has a few suggestions and workarounds.