Conditional coloring of columns in column chart

[Guest]

Hi,

Is there any way to have the columns in a column chart (Excel 2003) colored
such that the color of a column depends upon a variable.

Reason is- I want to columns to be gray when they are associated with
p-value >0.05 and blue if they are associated with p-value <=0.05. Right now
I am making do with partially transparent overlays but there may be a more
elegant and automated way of doing this.

Many thanks!
Arun

 

[Ed Ferrero]

Hi Arun,

There is a sample at
http://www.edferrero.com/ExcelCharts/tabid/102/Default.aspx
Look for 'Conditional Format Bar Chart'

Ed Ferrero
www.edferrero.com

 

[Guest]

Hi,

For more informationon about Conditional Formatting and Charts, please refer
to the following addresses:

A. http://www.xldynamic.com/source/xld.cf.html
B. http://www.contextures.com/xlconFormat01.html
C. http://peltiertech.com/Excel/Charts/Combocharts.html

Note: Some addresses are case-sensitive. If you are not redirected to the
appropriate urls, please verify your address.


Challa Prabhu