• 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.

Formatting error bars

mkapashi

New Member
Is it possible to conditionally format individual error bars i.e. if value of error bar 2 is less than error bar 1 then error bar 2 is red else green?
 

Hui

Excel Ninja
Staff member
Mkapashi


The only way I can see to do that is to have 2 data series with same values

One series can have no fill color and so isn't visible

Add + error bars to one series

and - error bars to the other series

You can then color them as you wish

But without using some VBA code there is no way to do it based on values
 
Top