Forum Discussion

serenitynetworks's avatar
serenitynetworks
Copper Contributor
Apr 08, 2025

Create chart that ignores zero values

I want a chart that graphs the miles I've run by week.  The data range is simple.

WeekMiles
10
20
320
425
525
60
70
...520

For the graph, I'd just like to show weeks 3 thru 5.  When data is entered for weeks 6, 7, and so on, then the values for those weeks would automatically appear in the chart.

I can use the filter to filter out zeros in the data, but then that hides rows (which hides other charts and data that I want shown).

Is there another way that I can have my full data range showing (weeks 1 thru 52), but have my chart ignore zero mile values?

Thanks in advance,
Andrew

1 Reply

  • You can use the FILTER function to returns the rows with non-zero miles to another range.

    Then use that range as data source for your chart.

Resources