LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 103
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
conditional cell coloring phrodude Excel Worksheet Functions 5 July 28th 06 12:15 AM
conditional cell coloring phrodude Excel Discussion (Misc queries) 5 July 27th 06 04:26 PM
Coloring of Excel Chart Darryn Lavery Charts and Charting in Excel 1 July 6th 06 09:07 AM
Chart Coloring a Charts and Charting in Excel 1 June 20th 06 09:45 PM
conditional coloring Krishna Mohan Excel Worksheet Functions 2 April 19th 05 02:02 PM


All times are GMT +1. The time now is 08:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"