| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Bar Charts that I don't want labeled within the chart
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? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Bar Charts that I don't want labeled within the chart
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? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Bar Charts that I don't want labeled within the chart
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? |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Bar Charts that I don't want labeled within the chart
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? |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Bar Charts that I don't want labeled within the chart
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? |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Bar Charts that I don't want labeled within the chart
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? |
|
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Bar Charts that I don't want labeled within the chart
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? |
|
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Bar Charts that I don't want labeled within the chart
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? |
|
#9
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Bar Charts that I don't want labeled within the chart
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? |
|
#10
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Bar Charts that I don't want labeled within the chart
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Columns Labeled | Excel Discussion (Misc queries) | |||
| Labeled Coordinate Plots | Excel Discussion (Misc queries) | |||
| Your Excel download templates need to be labeled. | Excel Discussion (Misc queries) | |||
| Columns in Excel labeled numbers rather than letters? | Excel Discussion (Misc queries) | |||
| Plot many X-Y points with each being labeled with an ID | Excel Discussion (Misc queries) | |||
Linear Mode
