Menu
I have a google sheet with multiple rows of data I am trying to put into a pie chart. The problem is that it reports on blank values as a separate category (not really blank though, they are set to "" as a result of a formula). Is there a way to suppress these blanks?
251
To ignore blank cells with functions operating on a criteria_range and a corresponding criterion is to write the condition "<>" in the criterion.
Click the filter icon in cell A1 and uncheck the student names 'a' and 'b' and hit the “OK” button. This will exclude the relevant rows from the Sheet and also from your chart.
Hide Blank Rows in Google Sheets Once you insert the formula (=COUNTA(B2:E2)) in Column F, turn on the filter by going to Data > Create a filter. 2. To filter out zero values, (1) click on the filter icon in the F1 cell, (2) uncheck 0, and (3) click OK. All blank rows are now hidden.
Since I had the same issue, here how to solve it (at least for line charts):
Double click on the chart so the Chart editor opens. In the tab Customize open Chart style and check the checkbox Plot null values.
Thats it, now empty lines / cells will be ignored and the line will be plotted to the next existing value.
181
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
