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

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 he

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

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


"Bethb" wrote in message
...
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

Desired results achieved - Many thanks!

"Jon Peltier" wrote:

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 he

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

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


"Bethb" wrote in message
...
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