Vary bar colors by bar

I would like to vary the colors on a bar chart by bar.
The chart plots 7 points agains a standard.
The standard has the value of 100.
The points change based on information received weekly.
This will cause the bars to, sometimes, be above the standard and,
sometimes, below the standard.
How can I force the bars to change colors with every update so that when the
bar goes over the chart it will be green but when it falls below the chart it
will be red?

Tim

Hi,

Have a look at Jon's example of conditional charting.
http://peltiertech.com/Excel/Charts...onalChart1.html

Cheers
Andy

Tim wrote:
> I would like to vary the colors on a bar chart by bar.
> The chart plots 7 points agains a standard.
> The standard has the value of 100.
> The points change based on information received weekly.
> This will cause the bars to, sometimes, be above the standard and,
> sometimes, below the standard.
> How can I force the bars to change colors with every update so that when the
> bar goes over the chart it will be green but when it falls below the chart it
> will be red?
>
> Tim

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info