nystagmenos
New Member
- Joined
- Jan 27, 2014
- Messages
- 3
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
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