Search code examples
google-sheetspie-chart

Do not include NaNs in pie chart Google Sheets

How can I plot a pie chart without including the NaNs that are present in the column of interest?

enter image description here

Solution

  • Use =filter(A2:B, not(iserror(B2:B))) to omit rows that show NaNs. Then insert a chart that uses the filtered results as its data range.