Yes it should so colour in bar but no label.
Did you try it?

Cheers
Andy

VenusITN wrote:
Will that still show the color but not put a label on it? It is on the right
track, never thought to do this. I want it to not have a label if it is
below 3%? Think if I put nothing as the solution it would not put a label???

Thanks for your help,
VenusITN

"Andy Pope" wrote:


Hi,

Try this custom number format on the data labels.
[0.03]0%;

Cheers
Andy

VenusITN wrote:

I am doing bar charts based on percentages. My titles are Poor, Fair, Good,
Excellent. Usually the % for Poor or Fair is 0% but if it is 2% for Poor and
1% for Fair it looks like 21% because of the size. If it is under 3% I don't
want it to show the title but I still want to show it via color in the chart
so we know there was something chosen other than zero. Is there an If,Then
type of statment I can use to correct this?