This problem has been bugging me for ages, but I finally worked it out. In Excel 2007, right click on the chart and choose 'select data'. Click the button in the bottom left that says 'Hidden and...