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.

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.

sheets.google.com

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.