I have a table with entries (name and price) and some empty rows for future additions.
I have a pie chart that represent the total price distribution, so I know how much each entry contributes.
Problem is that the padding empty rows I have are at 0 or blank, and they are displayed in the chart legend.
So my legend looks like this:
How can I tell the chart pie to ignore #N/A or blank or 0 ?
I dont want to have to redefine the data range of the pie everytime I add/remove an entry.