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