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

[Guest]

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.

 

[Jon Peltier]

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

http://peltiertech.com/Excel/Charts/ConditionalChart2.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/ChartsHowTo/ClusterStack.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
_______