Removing value 0 from Google Sheet

Hi,

I wonder how I can “remove” 0 values in a line chart built with Google Sheets?

My sheet looks like this:

https://docs.google.com/spreadsheets/d/1X_EQcOt3Dpq1XqCuXkBS3OLro_DTcmVuNIAdi0D1e8w/edit?usp=sharing

And the line chart I get, when selecting both columns, looks like this (I’m only interested in plotting the bit in red):

Hi @Stephen :wave:

Funny you should ask. I was just publishing this article https://support.geckoboard.com/hc/en-us/articles/360011103278/ that explains how to remove the blanks (anything outside the red area).

I made a copy of the spreadsheet linked on your post to clarify a bit better. In my own copy, you’ll see a new “For Geckoboard” sheet where I use filter and ISBLANK to get only the columns with data and in the correct order:

https://docs.google.com/spreadsheets/d/1sHTi-_LgIp6TOK5CbuIyNOrBxYLSQqmtsLQ5WEYndUY/edit#gid=1600897106

I then used that data in Geckoboard to create this line chart:

Which I assume looks the way you envisage.

1 Like

Thank you @luis that’s exactly what I needed! :tada: