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.