Specifying colors for a bar chart up front rather than changing the automatically assigned ones?

%3CLINGO-SUB%20id%3D%22lingo-sub-1602859%22%20slang%3D%22en-US%22%3ESpecifying%20colors%20for%20a%20bar%20chart%20up%20front%20rather%20than%20changing%20the%20automatically%20assigned%20ones%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1602859%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20constantly%20changing%20the%20color%20of%20individual%20data%20points%20in%20bar%20charts%2C%20pie%20charts%2C%20etc.%20because%20I%20am%20interested%20in%20reinforcing%20categories%20of%20data%20by%20using%20similar%20colors%2C%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20question%3A%26nbsp%3B%20Is%20there%20some%20way%20to%20assign%20the%20color%20you%20want%20associated%20with%20a%20particular%20data%20point%20in%20a%20chart%20BEFORE%20you%20build%20it%2C%20so%20that%20you%20don't%20have%20to%20edit%20it%20post-creation%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20read%20articles%20about%20how%20to%20assign%20colors%20conditionally%20to%20data%20points%20in%20charts%20(for%20example%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fpeltiertech.com%2Fconditional-formatting-of-excel-charts%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpeltiertech.com%2Fconditional-formatting-of-excel-charts%2F%3C%2FA%3E)%20but%20even%20in%20these%20situations%20it%20seems%20you%20have%20to%20accept%20the%20initial%20automatic%20assignment%20of%20a%20color%20which%20you%20may%20not%20like.%26nbsp%3B%20I%20want%20to%20avoid%20having%20to%20edit%20my%20data%20points%20to%20one%20at%20a%20time%20following%20creation.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20much%20appreciated!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1602859%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1603070%22%20slang%3D%22en-US%22%3ERe%3A%20Specifying%20colors%20for%20a%20bar%20chart%20up%20front%20rather%20than%20changing%20the%20automatically%20assigned%20ones%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1603070%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F766440%22%20target%3D%22_blank%22%3E%40ksingley57%3C%2FA%3E%26nbsp%3BPerhaps%20this%20link%20will%20help%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.officetooltips.com%2Fexcel_365%2Ftips%2Fhow_to_change_the_default_colors_that_excel_uses_for_chart_series.html%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.officetooltips.com%2Fexcel_365%2Ftips%2Fhow_to_change_the_default_colors_that_excel_uses_for_chart_series.html%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I am constantly changing the color of individual data points in bar charts, pie charts, etc. because I am interested in reinforcing categories of data by using similar colors, etc.

 

My question:  Is there some way to assign the color you want associated with a particular data point in a chart BEFORE you build it, so that you don't have to edit it post-creation?

 

I have read articles about how to assign colors conditionally to data points in charts (for example, https://peltiertech.com/conditional-formatting-of-excel-charts/) but even in these situations it seems you have to accept the initial automatic assignment of a color which you may not like.  I want to avoid having to edit my data points to one at a time following creation.

 

Any help much appreciated!

1 Reply