Conditional Formatting on Bar Graph

Efraim · 2025-01-21T15:39:20+00:00

There was an error rendering this rich post.

Hello,

I may have missed something here but is it possible to apply conditional formatting on a Bar Cartesian so that all bars that have positive values will be green and negative values red?

As of now, I can only format the graph background by using the Color Alert, and Visible and color blocks in Object Settings.

Find more posts tagged with

Accepted answers

Bettina Clausen

HI,

you could use two algorithm instead of the alert to get your desired result.
In that case you have an algorithm/block that you can color in red for a negative value and an algo/block for positive/green figures:

Hope this helps.

All comments

Bettina Clausen

HI,

Hope this helps.

Efraim

Thanks @Bettina Clausen !
This really helped and I set the Series combine mode to Stack so that there will be no gaps.

Luca Signori

You can also use 'hide zeros' on blocks b and c to only show one bar.