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.

Highlighted

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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
203 Replies