software

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--
koootzz
------------------------------------------------------------------------
koootzz's Profile: www.excelforum.com/member.php...oamp;userid=30982
View this thread: www.excelforum.com/showthread...hreadid=506495Hi,

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

Cheers
Andy

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

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info