Chart bar with 3 colors ... red, yellow, green
In Excel 2010 you know we have the Conditional Formatting->Color Scales and then the first ones are red yellow and green. Well I would like my Bar chart to do the same.
That is … I have the Bar chart … say in % … so the maximum would be 100% … say we divided this 100% in 3 parts, 3 colors, so that the red and yellow fading out borde will be around 33% and the yellow
and green zone will be around 66%.
Now … if my data says that one bar is only 25% … well the three colors shouldn’t be in that little bar … I would like to only red … as the border of 33% has not yet been reached.
It’s hard to explain … but really the colors should be fixed by the maximum 100% and not by how long the bar will be and then try to fit in the colors in there.
How do I do this?
View Complete Post