Bar Charts that I don't want labeled within the chart

[VenusITN]

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?

 

[Andy Pope]

Hi,

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

Cheers
Andy

 

[VenusITN]

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

Hi,

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

Cheers
Andy

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?

 

[Andy Pope]

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

Cheers
Andy

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

:

Hi,

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

Cheers
Andy

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?

 

[VenusITN]

Nope it didn't work for me. I am going to play with the suggestion though.
Think it will work with that. Wondering if I leave out the 0% part if it
would leave it blank?

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

Cheers
Andy

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

:

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?

 

[VenusITN]

Andy,

I found an easy solution, just delete the label. Never thought about doing
that, thought if I deleted I would get rid of the actual bar. Have 130
people here at my office, no one could help but now they all think I am the
expert. LOL

thanks so much!!!!

Nope it didn't work for me. I am going to play with the suggestion though.
Think it will work with that. Wondering if I leave out the 0% part if it
would leave it blank?

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

Cheers
Andy

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

:


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?

 

[Andy Pope]

Deleting the label will obviously work. But if the data changes those
deleted labels will not return unless you re-apply labels and delete again.

If you want to email me an example of your chart I will take a look.

Cheers
Andy

Andy,

I found an easy solution, just delete the label. Never thought about doing
that, thought if I deleted I would get rid of the actual bar. Have 130
people here at my office, no one could help but now they all think I am the
expert. LOL

thanks so much!!!!

:

Nope it didn't work for me. I am going to play with the suggestion though.
Think it will work with that. Wondering if I leave out the 0% part if it
would leave it blank?

:

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

:



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?

 

[VenusITN]

Which email should I send it to? You are so correct,if I take it out it is
gone. And there could be 10 with 0% but the one with 15% sends a red flag
and we want to be able to see it.

 

[Andy Pope]

email addy is

andy AT andypope DOT info

Which email should I send it to? You are so correct,if I take it out it is
gone. And there could be 10 with 0% but the one with 15% sends a red flag
and we want to be able to see it.

:

 

[VenusITN]

Andy,

It is on it's way. Thank you soooooo much!!!!

Allison