How to make the chart still appearing after the table data is hidden in Excel 2007

1. Right-click on your chart and choose 'Select Data'

2. Click the 'Hidden and Empty cells' button in the lower left

3. Check the box for 'Show data in hidden rows and columns', click OK twice.

4. Hide your data.

Reference:

http://www.excelforum.com/excel-charting/658523-chart-disappears-when-i-hide-columns-with-values.html