Hi Arun,

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

Ed Ferrero
www.edferrero.com

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