How to show Negative Data Label Values in Red - Waterfall Chart

I have a waterfall chart pasted below:
Is there any way I can format negative data label values in Red? For example, I want to show negative values ($4,000) and ($5,000) in Red. I've tried somethings - changing data source's format, changing "Currency" format under Format Data Labels - nothing worked so far. Thank you.


Untitled.jpg

Hi,

Welcome to the Forum.

I am not sure if you can change the axis labels based on the values (+/-), however, you can invert the color of the bars if they are negative using "Invert if Negative". Please go through the following URL for more details.


http://peltiertech.com/WordPress/are...t-if-negative/

Thanks for your response. I am aware of changing bar colors but wanted to know if I can change the color of the data labels to Red automatically if the value is negative. Anybody else?