[SOLVED] Bars that reaches a value turns into a specific color?

[boho]

How can i make so the bars that reaches a value in the chart to turn into a
specific color and those which doesn't reach the value turns into another?
The type of chart i'm using is "Clustered Column" and in the chart there is
also a line type chart which is indicating where the goal is reached (it's
just a goal line, i don't think you need to bother this part of the chart).
I'm using excel 2002 sp3.
Any help is highly appreciated!

[Andy Pope]

Hi,

See Jon's example of conditional charts.
http://peltiertech.com/Excel/Charts/...nalChart1.html

Cheers
Andy

boho wrote:
> How can i make so the bars that reaches a value in the chart to turn into a
> specific color and those which doesn't reach the value turns into another?
> The type of chart i'm using is "Clustered Column" and in the chart there is
> also a line type chart which is indicating where the goal is reached (it's
> just a goal line, i don't think you need to bother this part of the chart).
> I'm using excel 2002 sp3.
> Any help is highly appreciated!

--

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