Chart label Conditional formatting

Maik Burghardt

Hi there,

any idea how to show positive and negative numbers in a chart in different colors?

Thank you, Maik

Dorra Ben Hmida

Hi @Maik Burghardt , I would suggest to use the options below :

Please take a look at the following link to know more about it :

https://www.boardmanual.com/2021/summer/whats-new-release-notes/winter-2021-release/main-features/The_new_Waterfall_chart_Object.htm

Maik Burghardt

Hi @Dorra Ben Hmida am I correct is this "feature" only available for waterfall charts?

If yes I think that is weird since I am sure that waterfall charts are not the most used charts on the platform?

However a simple BAR Chart probably is and displays positive and negative values but colors cannot be formatted ?

Thanks Maik

Remo Bollhalder

Hi @Maik Burghardt

You can use algorithms to display negative / positive values as different blocks and format them individually.

Maik Burghardt

@Remo Bollhalder can you share an example for a BAR Chart? Maybe that makes it clearer what I need to do.

Remo Bollhalder

You have to create two algorithms, which check if the source is positive or negative. You then have two blocks in the chart options under series, which you can format as you like.

Maik Burghardt

https://community.board.com/discussion/comment/18223#Comment_18223

It works. But I still think it is too complicated when there are simple options to manage +/- values is in the Waterfall Chart