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
