I have a pie chart based on a data range which contains zero-values. I would like to hide corresponding labels from chart legend, so it only displays the ones that are actually presented on the pie. example
if your data has a lot of zero values randomly distributed, you might want to use a filter
Mark all data rows including the zeros values
Standard Filters ...
Specify filter rule which rows to show/display
And here the modified example with the activ filter:
Hope that helps.
To show the community your question has been answered, click the ✓ next to the correct answer, and “upvote” by clicking on the ^ arrow of any helpful answers. These are the mechanisms for communicating the quality of the Q&A on this site. Thanks!
Have a nice day and let’s (continue to) “Be excellent to each other!”
Ask / Getting Started:
you didn’t show chart legend. I tried and that does not help at all. it’s not about hiding the rows, but labels in the legend what you’ve shown has nothing to do with a chart…
i updated my answer with the “chart legend” aka result view. As you can see, the legend doe not contain the zero values, after applying the filter. Hope that helps.
@igorlius thanks, but screenshots aren’t that helpful since I had different result… could you attach the example so I can play with it?
Sure, i’ll add the file, to my answer.
Also can use menu
AutoFilter, and unselect
☑ 0 on column B.
Only select the cells which contain values of more than 0, then start the charts assistant. If not selected the chart won’t display the null values…
quite obvious although those cells values change dynamically depending on other cells, I don’t want to manually update the chart each time that happens…