Bar charts: change color of a bar if value too high?
 

Hello,

I would like to create a bar with 3 series (2bars, 1trend). On the bars, I
would like that above a certain value, the bar change of color (just the part
above the value), is it possible?
Thank you.

Bar charts: change color of a bar if value too high?
 

This is complicated by having multiple series to begin with. For the
conditional coloring, you can use this approach:

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

To get this along with the clustered columns, you need to apply the
staggered data as described in the examples linked from this page:

http://peltiertech.com/Excel/ChartsH...sterStack.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"antoine" wrote in message
...
Hello,

I would like to create a bar with 3 series (2bars, 1trend). On the bars, I
would like that above a certain value, the bar change of color (just the
part
above the value), is it possible?
Thank you.