Excel Video 467 reviews the Hidden and Empty Cells button in the Excel 2013 Select Data Source window. You’ll see three options for dealing with missing data or empty cells in your source data. There’s not one right answer here. Depending on the data you’re charting and the message you’re trying to convey, you may each of the empty cells options in different charts.
Hidden data is a different story. I rarely hide data because when I come back to the spreadsheet later I often forget that data is hidden. With Excel 2013’s ability to quickly filter data out of a chart, there are fewer reasons to hide chart data. I prefer to filter data out of a chart rather than hide data, but if you need to hide data but have it appear on a specific chart, here’s how to do it.