Creating a Graph in Google Sheets

by danielr24 in Living > Education

12 Views, 1 Favorites, 0 Comments

Creating a Graph in Google Sheets

GraphFin.png
GraphFin.png

Google Sheets Graph feature allows you to turn raw data into a variety of graphs. Whether you’re tracking sales patterns or creating graphs for biology class, Google Sheets have bar charts, line graphs, pie charts, and anything else that fits your needs.

Supplies

  1. A laptop or device with internet access
  2. A Google Account
  3. A Google sheets document with complete data set

Create a Complete Raw Data Set

RawData.png

The data displayed in the graph cannot be directly edited. Ensure that your data is complete before generating any graphs.

Open Graph Menu

Chart menu.png

Step 2.1. Select “Insert” on the toolbar

Step 2.2. Select “Chart” in the pop-down menu

This will create a graph you can use if it meets your qualifications. If you wish to create a different graph or to change any features, keep reading

Select Graph Type

Chart Selector.png

Step 3.1. In the “Setup” tab, click the “Chart type” drop-down menu

Step 3.2. Select the type of graph you want from the selections

Edit Title/Axis

EditTitles.png

Step 4.1. In the “Customize” tab, click “Chart and Axis Title”

Step 4.2. in the “Chart and axis Title” tab, click “Chart Title” and select which axis/title you wish to edit

Step 4.3. Change the title/color/font/size of whatever you choose

Although there are many more settings you can adjust on the graph, the title and axis are the most used features, so I’ll just focus on those. If you wish to change other features, they follow a similar format.