Formatting error bars

[mkapashi]

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]

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