Exclude zeros from my pie chart

[stephenp12]

How do I hide 0's from my pie-chart (see attached).

Thanks in advance

S

[Greg M]

Hi there,

As the attached workbook shows, you can use a helper row to convert zero values into #N/A values, and then instruct the chart to take its data from the helper row - the #N/A values are not displayed on the Pie Chart (although their associated legend entries will still appear).


Hope this helps - please let me know how you get on.

Regards,

Greg M

[stephenp12]

Thank you, sorry i missed this