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'
If you're unlucky enough to still be using this dinosaur of a program in 2022, quite frankly, you can't stop it from changing colors back to the template defaults. Basically this happens because Microsoft believes they know what you want better than you do in every single instance, even down to the colors you choose.
Go get Smartsheet, or basically any other modern spreadsheet software. It's the 21st century.