Colour Grouping of Columns

[WSF]

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

 

[John Mansfield]

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/Charts/ConditionalChart1.html

http://www.peltiertech.com/Excel/Charts/ConditionalChart2.html