• 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


  • 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


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?


Excel Ninja
Staff member

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