Hiding labels

**kik** · 02-09-2007, 12:46 PM

Hi,

I'm using pie charts with lables (percentage and category) and I'm trying to hide the blank data labels as they all get mashed together and are unreadable. Can anyone help?

Thanks.

**oldchippy** · 02-09-2007, 06:12 PM

Take a look at this link, scroll down to Hide Zeros in Data Labels

http://peltiertech.com/Excel/NumberFormats.html

**kik** · 02-09-2007, 08:18 PM

I can't believe I spelt label wrong!

Thanks for the reply OldChippy (love the name by the way!). That's much better, but is there anyway I can scrap the category labels for the zero values?

Quick example in my pie chart:

Monday = 10%
Tuesday = 0%
Wednesday = 0%
Thursday = 50%
Friday 35%
Saturday = 10%
Sunday = 5%

Using the method outlined on the site, Tuesday and Wednesday's percentage label vanishes, but the category label remains.

Thanks

**oldchippy** · 02-10-2007, 05:17 PM

Hi kik,

Yes you can clear the Data Labels, if you click on Tuesday on your chart, it automatically selects all the days, click again on Tuesday then you have just this one selected - right click clear. Do the same for Wednesday.

Now go to the Legend and click that ,then click Tueday - right click clear. Do the same for Wednesday.

NOTE: If you update your data so that they are no longer 0%, you will have to click the chart - right click Chart Options > Data Labels and re-select Category Name.

For the Legend, click on it - right click delete. Select the chart again - right click Chart Options > Legend and select Show Legend

Hope this helps?