View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default 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?