Conditional coloring of columns in column chart
 

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

Conditional coloring of columns in column chart
 

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

Conditional coloring of columns in column chart
 

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