How to Hide Empty Data in Excel Graphs. If you have an Excel spreadsheet that contains empty data, such as empty rows or columns, and plot a graph from the spreadsheet, Excel plots all empty data.

With Excel's versatile chart tool, putting together data visualizations is as easy as pie (groan).

To change all data labels, click anywhere in the chart. To modify all labels on either the x or y-axis, click anywhere within the data series. To modify a single data label, click on the data label.

Although zero values are valid, you might need to hide them. Here are three methods for hiding zero values in an Excel sheet.