Bar chart

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
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Watch MrExcel Video

Forum statistics

Threads
1,095,804
Messages
5,446,564
Members
405,408
Latest member
Bravomb96

This Week's Hot Topics

Top