If you want to improve your knowledge of Excel charts, you could benefit greatly from our Essential Skills Books and E-books.

There are a few questions that we often receive regarding zero values in charts.

Filters are those gray arrows that appear at the top of columns in Excel.

If your data doesnt have filters, you can switch them on by clicking Data Sort Filter Filter on the Excel Ribbon.

If you create a chart from the filtered data it will not show any of the zero values.

Excel charts have options that control how they will respond to hidden and empty cells.

To access these options, select the chart and click: Chart Tools Design Select Data Hidden and Empty Cells.

With Line charts you can choose whether the line should connect to the next data point if a hidden or empty cell is found.

If you are using Excel 365 you may also see the Show NA as an empty cell option.

The final checkbox lets you tell Excel that it should display data that is in hidden rows or columns.

You might select this option if you wanted to filter your data without affecting the chart.

All of these settings are covered in much greater depth in our Essential Skills books and E-books.

If you want to improve your Excel skills they could be extremely useful to you.

Ms Excel 2011 For Mac Hide Zero Values In Excel Chart