Click the Insert tab and choose PivotChart from the Charts group. In the resulting dialog, choose Line in the list to the left, and click OK. Figure F shows the two pivot objects side by side.

Open the Excel spreadsheet with the data you wish to use in your line graph. Make sure all of the data is correct. 2. Click and drag your cursor to highlight all of the rows and columns with data ...