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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
_______
 
Back
Top