WSF,

Yes, you can do so by setting up various ranges with IF statements and
multiple culumns. Please see Jon Peltier's discussions on conditional
charting:

http://www.peltiertech.com/Excel/Cha...nalChart1.html

http://www.peltiertech.com/Excel/Cha...nalChart2.html

----
Regards,
John Mansfield
http://www.pdbook.com


"WSF" wrote:

Excel 97
Is there a way to colour the columns in a chart depending on their
numerical range. For example:

Say we have a series of values from 0 through 100 represented in the
column chart.

I would like 0-25 to be one colour, 26-50 to be another, etc etc.

Is this possible?

Any advice gratefully appreciated.
WSF