Hi everyone
I have a pie chart from a dataset. I want to remove the 0% labels within the pie chart.
I would manually remove them but the numbers can change based on parameters. I also have 28 of these pie charts.
Thanks
Hi everyone
I have a pie chart from a dataset. I want to remove the 0% labels within the pie chart.
I would manually remove them but the numbers can change based on parameters. I also have 28 of these pie charts.
Thanks
Try this:
First, delete the zero values. If using formulas, include condition to exhibit #N/A instead of zero.
Over chart area, right button options, click Select Data.
At dialog box, click Hidden and blank cells.
At new dialog box, click Show data in hidden rows and columns.
Not sure about precise English version for those commands, but they will show something like that.
Godspeed!
Last edited by Estevaoba; 07-25-2017 at 05:14 PM.
Hi,
If you only need to remove the data labels, you can apply a custom numberformat of 0%;-0%;; to them, so that 0 values will not display.
Don
Please remember to mark your thread 'Solved' when appropriate.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks