Click on the top left corner of the data you'd like to include in your chart or pivot table.
2
Hold shift and click on the bottom right corner of the data you'd like to include in the chart or pivot table. This will highlight the whole section of data.
3
Click on the "Insert" tab.
4
For a chart, click "Chart."
5
For a pivot table, click "Pivot table."
6
Select whether you'd like to pivot table in a new or existing sheet, then click "Create."