Bar Graph Colours

Herbiec09

Active Member
Joined
Aug 29, 2006
Messages
250
Good evening All,

Is it possible for the colour of a bar on a bar graph to be determined by the size of the bar e.g. values between 0 & 2 are green, values between 3 and 5 are orange etc? If so, how do i do it?

Thank you
Herbiec
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

cyrilbrd

Well-known Member
Joined
Feb 2, 2012
Messages
4,071
Office Version
365
Platform
Windows, Mobile
Good evening All,

Is it possible for the colour of a bar on a bar graph to be determined by the size of the bar e.g. values between 0 & 2 are green, values between 3 and 5 are orange etc? If so, how do i do it?

Thank you
Herbiec
Hi have you tried Peltier's solution? link here. specifically this method here: link.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,806
Messages
5,446,572
Members
405,409
Latest member
croc23

This Week's Hot Topics

Top