software

I've got three team, A, B amp; C. Each team has a goal each month. I'm graphing
their actual values against their goals. I've got their Goal bar colored
blue. I'd like to color all the bars that are less than the goal red and any
bars equal or greater than the goal colored green. Is this possible?

I'm using Excel 2003 SP1

You can get the conditional formatting effect by using multiple series:

peltiertech.com/Excel/Charts/...nalChart1.html

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

quot;M.Silerquot; gt; wrote in message
...
gt; I've got three team, A, B amp; C. Each team has a goal each month. I'm
gt; graphing their actual values against their goals. I've got their Goal bar
gt; colored blue. I'd like to color all the bars that are less than the goal
gt; red and any bars equal or greater than the goal colored green. Is this
gt; possible?
gt;
gt; I'm using Excel 2003 SP1
gt;
gt;
gt;
Yep that worked... wish conditional formatting would be something MS would
put in the charting.

Thanks!

quot;Jon Peltierquot; gt; wrote in message
...
gt; You can get the conditional formatting effect by using multiple series:
gt;
gt; peltiertech.com/Excel/Charts/...nalChart1.html
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services
gt; Tutorials and Custom Solutions
gt; PeltierTech.com/
gt; _______
gt;
gt; quot;M.Silerquot; gt; wrote in message
gt; ...
gt;gt; I've got three team, A, B amp; C. Each team has a goal each month. I'm
gt;gt; graphing their actual values against their goals. I've got their Goal bar
gt;gt; colored blue. I'd like to color all the bars that are less than the goal
gt;gt; red and any bars equal or greater than the goal colored green. Is this
gt;gt; possible?
gt;gt;
gt;gt; I'm using Excel 2003 SP1
gt;gt;
gt;gt;
gt;gt;
gt;
gt;