bar graph color
 

Had several data on horizontal bar graph. How could i assign each of the bars
to change color depending on its value? (ex. 0-50 - red, 51-100 - orange,
....etc)

bar graph color
 

Hi,

Try a conditional chart, similar to one that Jon Peltier uses on his site.

http://peltiertech.com/Excel/Charts/...nalChart1.html

Dave



"Aimaner" wrote:

Had several data on horizontal bar graph. How could i assign each of the bars
to change color depending on its value? (ex. 0-50 - red, 51-100 - orange,
...etc)