Click on the top left corner of the data you'd like to include in your chart or pivot table.

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.

Select whether you'd like to pivot table in a new or existing sheet, then click "Create."

Google Sheets is a powerful online tool to help you do quantitative analysis. Learn how to use formulas to manipulate and analyze datasets, such as Google Sheets' COUNTIF and SUMIF functions, among many others.

Google Sheets

This guide provides step-by-step instructions on how to summarize data using charts and pivot tables. It is a useful resource for anyone looking to organize and present data in a clear and visually appealing way.

How to Summarize Data with Charts & Pivot Tables