then click the Chart Design tab. Click the Select Data button. Click the Hidden and empty cells button. Click the Show data in hidden rows and columns check box. Click OK for both dialog boxes.

and use the handle to AutoFill the rest of the column. Now that you've applied your new parameters to your table, you're ready to add this to your chart. Select the chart, open "Chart Design" on ...