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

  • Thread starter Thread starter VenusITN
  • Start date Start date
V

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?
 
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 said:
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?
Click to expand...
Click to expand...
 
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?
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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?
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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 said:
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?
Click to expand...
Click to expand...
Click to expand...
 
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?
Click to expand...
Click to expand...
Click to expand...
 
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.
 
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.

:
Click to expand...
 
Back
Top