How to add a series to a BarChart Data Source that will change the color of the bar according to the %

[luisitocarrion1900]

AM trying to a a new series to the data source that will change the color of the bar according to its %

For example if
Below 50% change the color to RED
Grater than 50 and less than 90 change the color to Yellow
greater than 90 and less than 100 change the color to Light Green
Equal 100 change the color to green

 

[Dave Paradi]

I think you can adapt the ideas in this article and video to create a column chart that has conditional formatting based on the values:

Conditional formatting for Excel column charts | Think Outside The Slide

www.thinkoutsidetheslide.com

Hope that helps
Dave