Bar Chart Conditional Formatting

Hi,

I have a horizontal bar chart in which some of the bars represent positive values and others represent negative values.

Can someone please tell me how to format the bars so the "positive" bars are shaded in one colour and "negative" bars in another colour? I'd prefer not to change the bar colour manually as the values change frequently.

Thanks!

There is an "invert if negative" option for the area colour.

Hi,

Thanks for this.

If I select the "invert if negative" option the "negative" bars are shaded white. If I want to shade the bars dynamically, blue if positive and red of negative, how do I do this?

Thanks