From the course: Google Sheets: Advanced Topics

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Exploring charts

Exploring charts - Google Sheets Tutorial

From the course: Google Sheets: Advanced Topics

Start my 1-month free trial Buy for my team

Exploring charts

“

To explore some of the problems you may encounter when trying to make a chart to analyze the data you've gathered, let's look at the spreadsheet from the basics course On the Rise monthly sales figures. Sometimes there's too much information to show a chart with meaning. Be careful the data range you select. You may only want to select a smaller section of the information. Column A is the North American region. Row one lists the quarters. Well, this information is helpful when looking at the data in the spreadsheet. It may not be helpful as you create the chart. You wouldn't want to select cells A1 through N10 to create a chart. Consider selecting only B2 through N10 to find information about the monthly sales for each region. To create a chart, select insert from the toolbar and select chart. In the chart editor, select the chart type line chart. For data range, type in B2:N10. For x axis, select region if it's not already selected by default. Under series, check switch rows slash…

Contents