Excel 2010: Can I hide columns without excluding the data from a graph?

Solution 1:

Solution

• Open the workbook and click a chart whose hidden data and empty cells you want to display.
• Click Design > Edit Data Source > Hidden and Empty Cells.
• Select 'Show data in hidden rows and columns'.
• From 'Show empty cells as', select an appropriate option then click OK.

Details

By default in Excel, the hidden data in rows and columns is not displayed in a chart. Empty cells are displayed as gaps. Excel allows you to display the hidden data and change the way the empty cells are displayed. Rather than displaying the empty cells as gaps, you can display them as zero values or you can span the gaps with a line.