Home

How can I stop Excel from changing the colors of my chart ?

%3CLINGO-SUB%20id%3D%22lingo-sub-336069%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20stop%20Excel%20from%20changing%20the%20colors%20of%20my%20chart%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-336069%22%20slang%3D%22en-US%22%3E%3CP%3EFile%20%26gt%3B%20Options%20%26gt%3B%20Advanced%20%26gt%3B%20Chart%20%26gt%3B%3C%2FP%3E%3CP%3Edeselect%20'Properties%20follow%20chart%20data%20point%20for%20current%20workbook'%3C%2FP%3E%3CP%3Edeselect%20'Properties%20follow%20chart%20data%20point%20for%20all%20new%20workbooks'%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-198812%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20stop%20Excel%20from%20changing%20the%20colors%20of%20my%20chart%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-198812%22%20slang%3D%22en-US%22%3E%3CP%3EI%20had%20the%20same%20problem.%20This%20%3CSTRONG%3Emay%3C%2FSTRONG%3E%20help%3A%3C%2FP%3E%3CP%3EIf%20possible%2C%20remove%20the%20filter%20and%20let%20excel%20draw%20the%26nbsp%3Bchart%20with%20all%20data%20(this%20may%20take%20a%20long%20time%20or%20even%20excel%20may%20hang%2C%20so%20save%20your%20data!).%20Setting%20back%20filters%2C%20you'd%20hopefully%20see%20the%20problem%20has%20gone.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-80950%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20stop%20Excel%20from%20changing%20the%20colors%20of%20my%20chart%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-80950%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eif%20this%20is%20a%20pivot%20chart%2C%20take%20a%20look%20at%20Jon%20Peltier's%20article%20%3CA%20title%3D%22Pivot%20Chart%20Formatting%20Changes%20When%20Filtered%22%20href%3D%22http%3A%2F%2Fpeltiertech.com%2Fpivot-chart-formatting-changes%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EPivot%20Chart%20Formatting%20Changes%20When%20Filtered%3C%2FA%3E%20It%20has%20a%20few%20suggestions%20and%20workarounds.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-80499%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20stop%20Excel%20from%20changing%20the%20colors%20of%20my%20chart%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-80499%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20is%20the%20data%20source%20for%20your%20charts%3F%20Are%20they%20power%20charts%2C%20or%20they%20are%20built%20on%20tables%2Franges%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-692594%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20stop%20Excel%20from%20changing%20the%20colors%20of%20my%20chart%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-692594%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20the%20Tip%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F282979%22%20target%3D%22_blank%22%3E%40mbiscotto%3C%2FA%3E%26nbsp%3Bit%20was%20driving%20me%20crazy%20!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-695938%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20stop%20Excel%20from%20changing%20the%20colors%20of%20my%20chart%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-695938%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F282979%22%20target%3D%22_blank%22%3E%40mbiscotto%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks!%20for%20the%20wonderful%20solution%20-%20it%20helped%20the%20issue%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-743636%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20stop%20Excel%20from%20changing%20the%20colors%20of%20my%20chart%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-743636%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F282979%22%20target%3D%22_blank%22%3E%40mbiscotto%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20a%20lot.%20This%20helped%20me%20a%20lot.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-80475%22%20slang%3D%22en-US%22%3EHow%20can%20I%20stop%20Excel%20from%20changing%20the%20colors%20of%20my%20chart%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-80475%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20chart%20with%20past%20and%20forecasted%20figures%20for%20several%20series%20of%20data.%3C%2FP%3E%3CP%3EI%20set%20the%20colors%20of%20each%20serie%20in%20order%20to%20have%20something%20nice%20and%20meaningful%20%3A%201%20color%20per%20serie%2C%20dotted%20for%20forecast.%3C%2FP%3E%3CP%3EEach%20time%20I%20filter%20my%20data%20to%20see%20a%20particular%20serie%2C%20Excel%20destroys%20my%20work%20to%20put%20back%20its%20automated%20layout%20which%20are%20ugly%20and%20meaningless.%3C%2FP%3E%3CP%3EHow%20can%20I%20prevent%20this%20%3F%3C%2FP%3E%3CP%3EI'm%20using%20excel%20professional%20plus%202013%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20a%20lot%20!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-80475%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharts%20%26amp%3B%20Visualizing%20Data%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-855613%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20stop%20Excel%20from%20changing%20the%20colors%20of%20my%20chart%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-855613%22%20slang%3D%22en-US%22%3E%3CP%3EThanks!%20It%20is%20good%20and%20help%20me%20so%20much.%3C%2FP%3E%3C%2FLINGO-BODY%3E
fabien.calendar
Occasional Visitor

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 !

8 Replies

Hi,

 

What is the data source for your charts? Are they power charts, or they are built on tables/ranges?

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. 

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.

File > Options > Advanced > Chart >

deselect 'Properties follow chart data point for current workbook'

deselect 'Properties follow chart data point for all new workbooks'

Thanks for the Tip @mbiscotto it was driving me crazy !!

@mbiscotto 

 

thanks! for the wonderful solution - it helped the issue 

@mbiscotto 

 

Thanks a lot. This helped me a lot. 

Thanks! It is good and help me so much.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies