Charting issue

You need to build a range of chart data that excludes zero values.

You can do that with formula.
Then you need to add 2 named ranges to specify want ranges to use for labels and data within the chart.
Finally you need to update the series data to reference the 2 named ranges.

Alternatively you could apply a filter to your chart data and unselect zeros.

Example of each in attached.