VBA to change chart's data label font color if value is below a certain number

[JennyLyons]

Hello,

I am working on making hundreds of bar charts. The bar color is a dark blue, so for visual purposes, we made the data label white. The problem is that in some instances, the bar value is so small that the white data label cannot be seen. Is there a way to write some code that changes all chart's data labels grey when the value is less than a certain number?

Thanks!
Jenny

 

[Fazza]

What about a custom number format? Needs no VBA. I don't recall the colours available. But IIRC they are something like red, black, blue, cyan, green, etc

For say less than 100 in red, you could have custom number format something like [<100][red]#,##0;#,##0
Or whatever you needed to suit your requirements

HTH