Automatically change the label colour in a bar chart?

[bruty]

I have a range of bar charts and the client has requested a white colour for the labels. That's all well and good until you get a 0% response and the label doesn't show up on the white background. Is there any way of formatting these labels automatically based on values or even better the chart length?

Or any alternatives would be greatly appreciated. I have tried to use black text, and suggested a grey, but the client is adamant on white text (and keeping the white background)

 

[KRice]

I believe the same two options came to my mind...discuss the issue with the client and 1) determine whether something other than a white colored font will satisfy the client, perhaps a medium gray, or 2) consider whether coloring the background plot area some other color, again perhaps light to medium gray, while keeping the white font would be acceptable. Both of those offer some hope that a "0" value will be visible.

 

[JamesCanale]

What about cheating? Something like this. Thick, bold text, outlined in the same color as the chart bars.

 

[KRice]

That's clever...I like that idea.

 

[bruty]

I believe the same two options came to my mind...discuss the issue with the client and 1) determine whether something other than a white colored font will satisfy the client, perhaps a medium gray, or 2) consider whether coloring the background plot area some other color, again perhaps light to medium gray, while keeping the white font would be acceptable. Both of those offer some hope that a "0" value will be visible.

Discussed both those options with the client and they are adamant they want white text and white backgrounds!

 

[bruty]

View attachment 34470
What about cheating? Something like this. Thick, bold text, outlined in the same color as the chart bars.

I really like this and think it will work. Many thanks.