Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional cell coloring | Excel Worksheet Functions | |||
conditional cell coloring | Excel Discussion (Misc queries) | |||
Coloring of Excel Chart | Charts and Charting in Excel | |||
Chart Coloring | Charts and Charting in Excel | |||
conditional coloring | Excel Worksheet Functions |