Conditional formatting of data labels in the Waterfall Chart Object

Question

Hi everyone,

I'm working with the Waterfall Chart Object and I'm trying to apply conditional formatting to the data labels (the values displayed above each bar).

My goal is the following:

* Positive values → label displayed in green
* Negative values → label displayed in red

For example:

+200  → Green label+180  → Green label+30   → Green label-50   → Red label-40   → Red label

Currently, the Waterfall behaves like this:

* The bars are correctly colored (green for positive contributors and grey/red for negative contributors depending on the style).
* However, the labels remain black, regardless of whether the value is positive or negative.

Here is what I have already tried:

* Enabled Color Alerts on the Data Blocks.
* Created Algorithm Blocks to calculate the values.
* Reviewed the official documentation for the Waterfall Chart Object.
* Searched the Board Community and found discussions about using positive/negative algorithms to split series, but these examples seem to focus on bar colors, not on data label colors.

My question is:

Is there any supported way to apply conditional formatting to the data labels in the Waterfall Chart Object so that positive values appear in green and negative values appear in red?

If this is not supported, what would be the recommended workaround?

Thank you in advance!

Hamza Mesbahi · Accepted Answer

Hi @Abdelilah ,

As of now, I don't know of any supported way to apply conditional formatting to the data labels in the Waterfall Chart based on their values.

As you correctly pointed out, the Waterfall Chart supports conditional coloring of the bars for increases and decreases, but this functionality does not extend to the data labels.

My recommendation would be to either rely on the bar colors to distinguish positive and negative values or consider using a different chart type if color coded data labels are a key requirement.

You may also want to submit an enhancement request through the Ideas Portal so this feature can be considered for a future release.

Kind regards,

Hamza