ERROR BARS - different colors

[#1]

Hi all,

I do have a bar chart with one dimenstion and to compare the actual values with target values, I decided to include error bars.

My questions is now, if there is any possibility setting color properties for these error bars?? if the error bar is above the actual value bar the colour should be green otherwise red.

Here a screenshot from the actual chart:

Thank you a lot for your ideas 🙂

Barbara

[Clever_Anjos]

I don´t think you can do it using error bars

Maybe adding a second expression with '1' as value and bar offset = the value, as a second expression you can set the color you want

[#3]

Here you can give your condition according to your requirement .

[Clever_Anjos]

Maybe like this