I have some data in excel that I want to graph in a pie chart (see image 1) where the text will be the labels and the numbers will turn into percentages. The problem is, when i go to graph the data, it shows the labels for ALL of the sections, even the ones that are 0% in the pie chart. So this really overtakes my entire chart. I do not want to manually select the data as this is a dynamic spreadsheet and sections that are zero now may not be zero down the line.
Is there a way to tell excel to not at all display the labels for the sections that are 0%??
as you can see in the current graph (second image), there are way more labels than there are sections in the pie chart, and it looks extremely busy.
Thank you!
1 Answer
See the articleHow to suppress 0 values in an Excel chartfor various solutions that depend on your context.
The easiest is in menu File > Options, Advanced tab, section "Display options for this worksheet", to uncheck the option of "Show a zero in cells that have zero value". This will suppress the display of the zeros, but they will still appear in the Format bar.
Another solution to suppress the zeros except from the category labels is to:
- Select the data range
- Click in the Home tab the small box at bottom-right of the Number group
- In the Format Cells dialog box, choose Custom and set "Type" to
0,0;;;.
For more details with screenshots see the linked article.
