SOLVED

Seeking help to create a bar chart where the bar changes colour when low, med or high

%3CLINGO-SUB%20id%3D%22lingo-sub-2047381%22%20slang%3D%22en-US%22%3ESeeking%20help%20to%20create%20a%20bar%20chart%20where%20the%20bar%20changes%20colour%20when%20low%2C%20med%20or%20high%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2047381%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20all%2C%20I'm%20using%20Excel%20on%20Mac%20and%20am%20seeking%20to%20replicate%20a%20file%20I've%20been%20given.%20%26nbsp%3BIt%20has%20bar%20charts%20that%20are%20red%20when%20in%20the%20low%20category%2C%20green%20when%20med%20and%20blue%20when%20high.%20%26nbsp%3BThe%20bar%20just%20changes%20colour.%20%26nbsp%3BHow%20could%20I%20make%20this%20happen%20please%3F%20%26nbsp%3BThanks%20so%20much%20for%20assisting%3A)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2047381%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2047581%22%20slang%3D%22en-US%22%3ERe%3A%20Seeking%20help%20to%20create%20a%20bar%20chart%20where%20the%20bar%20changes%20colour%20when%20low%2C%20med%20or%20high%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2047581%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F924135%22%20target%3D%22_blank%22%3E%40down-to-earth%3C%2FA%3E%26nbsp%3BThis%20requires%20a%20few%20extra%20steps%20by%20which%20you%20dynamically%20categorise%20each%20value%20in%20the%20groups%20for%20Low%2C%20Med%20or%20High.%20Then%20you%20create%20a%20stacked%20bar%20chart%20of%20the%20three%20series%20and%20format%20each%20series%20to%20the%20desired%20colour.%20See%20attached%20for%20an%20example%20chart.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2068153%22%20slang%3D%22en-US%22%3ERe%3A%20Seeking%20help%20to%20create%20a%20bar%20chart%20where%20the%20bar%20changes%20colour%20when%20low%2C%20med%20or%20high%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2068153%22%20slang%3D%22en-US%22%3EThanks%20Riny%2C%20fantastic-%20this%20was%20extremely%20helpful%20and%20exactly%20what%20I%20needed%20to%20know.%20THANK%20YOU%20SO%20MUCH!%20%3A).%20My%20apologies%20for%20my%20delayed%20reply%20I%20was%20unwell%20last%20week%20so%20had%20to%20take%20time%20out.%20Thanks%2C%20this%20is%20most%20helpful.%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-BODY%3E
New Contributor

Hey all, I'm using Excel on Mac and am seeking to replicate a file I've been given.  It has bar charts that are red when in the low category, green when med and blue when high.  The bar just changes colour.  How could I make this happen please?  Thanks so much for assisting:)

3 Replies
best response confirmed by down-to-earth (New Contributor)
Solution

@down-to-earth This requires a few extra steps by which you dynamically categorise each value in the groups for Low, Med or High. Then you create a stacked bar chart of the three series and format each series to the desired colour. See attached for an example chart.

Thanks Riny, fantastic- this was extremely helpful and exactly what I needed to know. THANK YOU SO MUCH! :). My apologies for my delayed reply I was unwell last week so had to take time out. Thanks, this is most helpful.