Columns change colour with value

Is it possible to make the columns in a bar chart change colour once th
data goes above a certain value i.e. if the data is below target th
column will be red, above target the column will be green.
Thank

--
koootz
-----------------------------------------------------------------------
koootzz's Profile: http://www.excelforum.com/member.ph...nfo&userid=3098
View this thread: http://www.excelforum.com/showthread.php?threadid=50649

Hi,

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

Cheers
Andy

koootzz wrote:
> Is it possible to make the columns in a bar chart change colour once the
> data goes above a certain value i.e. if the data is below target the
> column will be red, above target the column will be green.
> Thanks
>
>

--

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