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.

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

Excel's Auto Outline feature quickly hides detail noise so you can view just a summary of your data.

This column shows how to use the Data Table option in Excel’s What-If Analysis tool.

You can easily hide and unhide columns in Excel by individually revealing hidden columns or using the "Format" option to unhide all hidden cells.