• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional Formating for Bars in a Chart

U

uspatteks

New Member
Hi ,


I want to have conditional colors to Bars in a Bar CHart. If the figure is +ve then it should be Green or else should be Red. Can anybody tell me how to do that?


Thanks


Shruti,
 
use a stocked bar chart. You'll want to make a couple of helper columns. First one should be if(value>10,value,0). Second one should be if(value<=10,value,0). Plot the helper colums only.
 
What part is giving you trouble?


Here's a pretty explicit example.


http://dl.dropbox.com/u/1275899/conditionalbars.xlsx
 
You must log in or register to reply here.
Back
Top