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

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

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

"Arun" wrote:

> 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