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?

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?

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?

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?

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?

"Andy Pope" wrote:

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?

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!!!!

"VenusITN" wrote:

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?

"Andy Pope" wrote:

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?

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

VenusITN wrote:
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!!!!

"VenusITN" wrote:


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?

"Andy Pope" wrote:


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?

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" 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?

email addy is

andy AT andypope DOT info

VenusITN wrote:
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" 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,

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

Allison

"Andy Pope" wrote:

email addy is

andy AT andypope DOT info

VenusITN wrote:
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" 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?