Jan 10 2021 04:52 PM
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:)
Jan 10 2021 08:47 PM
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.
Jan 17 2021 12:01 AM
Jan 17 2021 12:05 AM
@down-to-earth You're welcome!
Jan 10 2021 08:47 PM
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.