How to ignore zeroes or empty values in a chart?

[OoDeLally]

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:

[color1] Item1

[color2] Item2

[color3] Item3

[color4] #N/A

[color5] #N/A

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.

Thank you!

[Lupp]

I think you can’t work with spare rows. Charts don’t accept calculated ranges.

However, there is a workaround: If you can accept one item row at the bottom to always remain in the bottom position, and you create new data rows by inserting them above, ranges referencing the data will be automatically expanded. This works for formulas and for connected charts as well.

If you insist on new data rows being added below, you need to enable
> 'Tools' > 'Options' > 'LibreOffice Calc' > 'General' > 'Input Settings' : 'Expand references when new columns/rows are inserted'
first, and then to insert each time a new row (or a group of rows) immediately below the previous bottom row via the bottom row’s context menu…