How to exclude table chart rows with no data?

[Karen_Gumerov]

Hello,

I have a table chart with some data by months and registers, let's say number of errors by each register. There are some rows with minus signs in all the columns. I need to get rid of them somehow, but I just cannot see where this can be done. I tried option to hide null values, but it has nothing to do with no data case. Is there any way to hide such rows?

[ali_hijazi · Accepted solution]

Edit->Select your chart-> on the right select Add ons->data handling->uncheck include zero values

[Karen_Gumerov]

Thank you Ali, that was helpful!