Thread
:
Columns change colour with value
View Single Post
#
2
January 30th, 2006, 08:09 PM posted to microsoft.public.excel.charting
Andy Pope
external usenet poster
Posts: n/a
Columns change colour with value
Hi,
See Jon Peltier's example of conditional charts,
http://peltiertech.com/Excel/Charts/...nalChart1.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
Andy Pope
View message headers