Colour Grouping of Columns
 

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

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