- 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'
by Martelcs on June 05, 2020
by mekremer on June 05, 2020
by Khanh_Mai on June 05, 2020
by cuong on May 27, 2020
by Ingeborg Hawighorst on May 13, 2020