06-21-2017
12:20 AM
- last edited on
07-25-2018
09:39 AM
by
TechCommunityAP
06-21-2017
12:20 AM
- last edited on
07-25-2018
09:39 AM
by
TechCommunityAP
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
Hi,
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
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.
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
SolutionFile > Options > Advanced > Chart >
deselect 'Properties follow chart data point for current workbook'
deselect 'Properties follow chart data point for all new workbooks'
06-14-2019 05:31 AM
Thanks for the Tip @mbiscotto it was driving me crazy !!
06-17-2019 05:29 AM
07-08-2019 02:43 PM
09-14-2019 05:26 AM
Thanks! It is good and help me so much.
10-28-2019 09:56 AM
Whoa! Thank you seriously for saving my day!
04-03-2020 02:35 PM
@mbiscotto thanks a lot. seriously.
04-04-2020 02:52 AM
I dont have this in my options tab, any other solutions possible? @mbiscotto
06-24-2020 03:41 PM
thank you so much for this, it has been driving me crazy
@mbiscotto wrote:File > Options > Advanced > Chart >
deselect 'Properties follow chart data point for current workbook'
deselect 'Properties follow chart data point for all new workbooks'
09-29-2020 09:39 AM
@mbiscotto I am looking to find this on excel 365 on mac, any ideas where it is? I checked preferences charts but couldn't find the option
09-30-2020 05:21 AM
@tharangaj not a Mac user (or know one), so can't help. feel free to write back after you've switched to PC/Win10...
09-30-2020 06:12 AM
@mbiscotto used the VBA script below and it worked. actually switched from PC recently.
Application.ChartDataPointTrack = False
ActiveWorkbook.ChartDataPointTrack = False
09-30-2020 06:17 AM
@tharangaj Excellent! suspected VBA could offer such a solution, but digging into VBA a bit much for typical users and hadn't time to validate this possibility.
10-27-2020 03:31 PM
you are a f***** LEGEND!
11-20-2020 06:17 AM
01-07-2021 10:28 AM
@mbiscotto You are a life saver!! Thanks!