Forum Discussion
Create chart that ignores zero values
I want a chart that graphs the miles I've run by week. The data range is simple. Week Miles 1 0 2 0 3 20 4 25 5 25 6 0 7 0 ...52 0 For the graph, I'd just ...
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.