SOLVED

Formatting Data Entry, Series Color Automatic Change Problem

%3CLINGO-SUB%20id%3D%22lingo-sub-3337215%22%20slang%3D%22en-US%22%3EFormatting%20Data%20Entry%2C%20Series%20Color%20Automatic%20Change%20Problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3337215%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there.%3C%2FP%3E%3CP%3EI%20created%20a%20file%20to%20show%20monthly%20amount%20distribution.%20I%20used%203%20colors%20which%20are%20blue%20for%20planned%2C%20green%20for%20actual%20and%20red%20for%20forecast.%20I%20only%20want%20to%20use%20these%203%20colors%20in%20my%20chart%20to%20show%20planned%2C%20actual%20and%20forecast%20monthly%20distribution.%20After%20i%20crete%20a%20table%20which%20includes%20all%20of%20them%2C%20i%20want%20to%20see%20each%20of%20them%20as%20using%20slicer%20in%20excel.%20as%20if%20montly%20concrete%20distribution%20for%20part-1%20or%20overall%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAfter%20i%20use%20my%20slicer%20a%20few%20times%20(%20Indeed%20after%20i%20choose%20one%20them%2C%20then%20i%20look%20for%20different%20combination%20and%20then%20i%20back%20previous%20combination)%2C%20my%20bar%20colors%20changes%20to%20automatic%20instead%20of%20solid.%20i%20don't%20want%20them%20to%20be%20automatically%20different%20colors.%20But%20after%20i%20play%20with%20my%20slicer%2C%20it%20changes.%20How%20can%20i%20make%20it%20stable%20without%20changing%20automatic%3F%20I%20need%20your%20help%20dear%20community%20members.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20Dear%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%20i%20wanted%20to%20mention%20you%20especially%2C%20because%20i%20always%20become%20amazed%20with%20your%20solutions.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20find%20documents%20about%20my%20problem%20which%20includes%20before%20and%20after%20excel%20files.%20You%20can%20see%20how%20colors%20become%20automatic%20and%20chart%20is%20broken.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3337215%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3337272%22%20slang%3D%22en-US%22%3ERe%3A%20Formatting%20Data%20Entry%2C%20Series%20Color%20Automatic%20Change%20Problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3337272%22%20slang%3D%22en-US%22%3E%3CP%3EI%20found%20it%20guys.%20There%20was%20a%20same%20topic%20here%20earlier%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3CBR%20%2F%3EI%20won't%20delete%20this%20one%20as%20hoping%20it%20helps%20others%20too.%20The%20solution%20is%3A%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EFile%20%26gt%3B%20Options%20%26gt%3B%20Advanced%20%26gt%3B%20Chart%20%26gt%3B%3CBR%20%2F%3Edeselect%20'Properties%20follow%20chart%20data%20point%20for%20current%20workbook'%3CBR%20%2F%3Edeselect%20'Properties%20follow%20chart%20data%20point%20for%20all%20new%20workbooks'%3CBR%20%2F%3E%3CBR%20%2F%3EIn%20any%20case%2C%20thanks%20guys.%20I%20love%20you%20!%20Continue%20to%20share%20your%20info%20and%20experiences%20!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi there.

I created a file to show monthly amount distribution. I used 3 colors which are blue for planned, green for actual and red for forecast. I only want to use these 3 colors in my chart to show planned, actual and forecast monthly distribution. After i crete a table which includes all of them, i want to see each of them as using slicer in excel. as if montly concrete distribution for part-1 or overall etc.

 

After i use my slicer a few times ( Indeed after i choose one them, then i look for different combination and then i back previous combination), my bar colors changes to automatic instead of solid. i don't want them to be automatically different colors. But after i play with my slicer, it changes. How can i make it stable without changing automatic? I need your help dear community members.

 

And Dear @Sergei Baklan i wanted to mention you especially, because i always become amazed with your solutions.

 

You can find documents about my problem which includes before and after excel files. You can see how colors become automatic and chart is broken.

 

Thanks in advance

 

 

1 Reply
best response confirmed by Sekoleyte (Occasional Contributor)
Solution

I found it guys. There was a same topic here earlier
I won't delete this one as hoping it helps others too. The solution is:


File > Options > Advanced > Chart >
deselect 'Properties follow chart data point for current workbook'
deselect 'Properties follow chart data point for all new workbooks'

In any case, thanks guys. I love you ! Continue to share your info and experiences !