Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

In Excel 2010, is it possible to hide columns but still have the values show up in a graph?

I have a graph of monthly data going back to 2005, with each month's data in a column. If I hide the columns, say, for everything before 2010, then the graph only shows the 2010 data.

Is it possible to hide the columns, but still have the data in the graph?

share|improve this question

1 Answer 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.

share|improve this answer
2  
Why did someone down vote this? It is the right answer. –  Sux2Lose May 16 '11 at 15:34
    
@Sux2Lose No idea! But I saw your comment and added my +1. –  pnuts Dec 21 '12 at 18:19

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.