From the course: Google Sheets Essential Training (2021)
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Creating charts and graphs - Google Sheets Tutorial
From the course: Google Sheets Essential Training (2021)
Creating charts and graphs
- Once you've entered data into your spreadsheet it's a quick process to turn that data into a chart or graph that you can display on your spreadsheet. Let's walk through the process of inserting a charter graph into your Google Sheet, based on data you've entered. I'll show you how using this solar panel chart spreadsheet. This file is called charts, and you'll find it in the exercise files, chapter six folder. Before you can create a graph or chart, you'll need to enter the data that will be used for your chart in at least a couple of rows and columns. It will also help to label the data in your spreadsheet with column and or row headers, before you create your chart. On this solar panel chart sheet, I have two columns. One labeled solar panel size square feet, and one labeled watts per panel. I'd like to make a bar graph with each of these labels on one axis. It helps that I've already created the labels as column…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.