Yes, have a look at Jon's examples of conditional charts.
http://peltiertech.com/Excel/Charts/...nalChart1.html
Cheers
Andy
bobf wrote:
Is it possible to have a bar chart where all values
greater than 100 are automatically coloured red, less than
100 are coloured green?
thanks
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info