Hi,

Have a look an Jon's example of conditional charts.
http://peltiertech.com/Excel/Charts/...nalChart1.html

Cheers
Andy

Zeeshan wrote:
hi,
I would like to develop a Bar chart, which changes its bar colour for
different data values. e.g for a cell format and to change colour of a cell
for different values we can use conditional format.

--

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