Format Column Chart Shading

[Bethb]

This seems like it would be a conditional issue, but I am at a complete loss.
I have a columnar chart comparing how long a route should take vs. how long
it is actually taking. Having the entire optimized column shaded is fine, but
I'd like to get only the portion of the actual column that exceeds the
optimization figure shaded. I.E. - if route 1 should take 10 hours, and it's
taking 12, the actual column should be shaded white or no shading up to 10
hours, then shaded another color from 10 to 12. Any advice will be most
gratefully recieved.

Beth

 

[Jon Peltier]

Make a stacked chart, where one column goes up to 10 hours, and the other
includes just the amount over 10 hours. This is similar to the conditional
charts described here:

http://peltiertech.com/Excel/Charts/ConditionalChart1.html
http://peltiertech.com/Excel/Charts/ConditionalChart2.html

- Jon

 

[Bethb]

Desired results achieved - Many thanks!

Make a stacked chart, where one column goes up to 10 hours, and the other
includes just the amount over 10 hours. This is similar to the conditional
charts described here:

http://peltiertech.com/Excel/Charts/ConditionalChart1.html
http://peltiertech.com/Excel/Charts/ConditionalChart2.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______