Bar chart

[nystagmenos]

Hi,
I am trying to get excel to change the colous by the lenght of each bar, automatically. We have 5 bar lenghts, is there some formula I can use so that for eg. bar with lenght 1 always comes up red, bar with lenght 2 always comes up yellow, etc. I can do this for a single graph but cannot get it consistently for every chart generated.
Thank you in advance

 

[VoG]

See if this helps Conditional Formatting of Excel Charts - Peltier Tech Blog