- last edited on
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.
Each time I filter my data to see a particular serie, Excel destroys my work to put back its automated layout which are ugly and meaningless.
How can I prevent this ?
I'm using excel professional plus 2013
Thanks a lot !
06-21-2017 02:17 AM
What is the data source for your charts? Are they power charts, or they are built on tables/ranges?
06-21-2017 03:02 PM
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.
05-30-2018 12:25 AM
I had the same problem. This may help:
If possible, remove the filter and let excel draw the chart with all data (this may take a long time or even excel may hang, so save your data!). Setting back filters, you'd hopefully see the problem has gone.
02-12-2019 02:31 PM
File > Options > Advanced > Chart >
deselect 'Properties follow chart data point for current workbook'
deselect 'Properties follow chart data point for all new workbooks'