How do I graph 3 variables in Google Sheets?

Home » How to Make a Line Graph in Google Sheets (Step-by-Step)How to Make a Line Graph in Google Sheets (Step-by-Step)Share Share Tweet Email PrintHow to Make a Line Graph in Goog

How do I graph 3 variables in Google Sheets?

Home » How to Make a Line Graph in Google Sheets (Step-by-Step)

How to Make a Line Graph in Google Sheets (Step-by-Step)Share Share Tweet Email Print

How to Make a Line Graph in Google Sheets  Video tutorial:

Nothing conveys and represents data as clearly as a line graph.

From statistics to evolving data, line graphs are a sure way to record and monitor informational changes accurately.

With the use of line graphs, trends clearly appear, allowing individuals and companies alike to adjust their operational procedures to reach their overall goals and objectives.

Let us explore line graphs in more detail, and discover how to make a line graph in Google She

This Article Covers:

  • What Is a Line Graph in Google Sheets?
  • Important Parts of a Line Graph
  • Purpose of Line Graphs
  • How to Make a Line Graph in Google Sheets With Multiple Lines
  • Step 1: Enter Data in Google Sheets.
  • Step 2: Highlight the Data, and Click on the Chart Icon.
  • Step 3: Choosing the Right Chart Type Settings
  • Step 4: Doing Some Chart Customization
  • Chart Style
  • Chart & Axis Titles
  • Series
  • Legend
  • Horizontal Axis
  • Vertical Axis
  • Gridlines
  • How to Make a Line Graph on Google Sheets FAQ
  • How Do You Make a Line Graph on Google Sheets?
  • How Do You Make an XY Line Graph in Google Sheets?
  • How Do You Make a Line Graph in Google Sheets With Two Sets of Data?
  • Lining up Your Next Graph

What Is a Line Graph in Google Sheets?

Before we dive into how to make a line chart in Google Sheets, lets examine what they are.

Line graphs have straight, solid lines connecting solid, data points called markers, and display the line segments chronologically.

Line graphs have an x-axis (or horizontal axis) and a y-axis (or a vertical axis), which differentiate between the categories and the measurement values, respectively.

For example, if a company wants to compare their revenue between 2018 and 2019, a line graph would be the best way to display the information and observe the trends.

Data shown in a line chart in Google Sheets

But before an effective and efficient line graph is created, its important to know what the essential parts of a line graph are. By understanding the different parts of a line graph, information can be displayed in the way it is meant to be conveyed.

So, lets examine the different parts of a Google Sheets line graph, and then discover the steps to create one!

Important Parts of a Line Graph

The important parts of a line graph include:

  • Y-Axis (vertical axis)
  • X-Axis (horizontal axis)
  • Chart Title
  • Markers
  • Grid
  • Y-Axis Label
  • X-Axis Label
  • Legend

Purpose of Line Graphs

But what exactly is a line graph? A line graph is a graph that displays the relationship between two or more changing quantities over time. However, a line graph can also display just one changing quantity if there is nothing to compare it to.

The best time to use a line graph is when you need to demonstrate trends, changes, increases, decreases, etc. A line graph is more intuitive to show changing and evolving trends than other types of graphs.
Check also other ways how to track changes in Google Sheets.

Line graphs are best used for:

  • Showing evolving data
  • Showing how two continuous variables relate to one another

So, lets dive right in and start creating a Google Sheets line graph.

How to Make a Line Graph in Google Sheets With Multiple Lines

Below are the steps to make a line chart in Google Sheets with multiple lines, to do a single line, you just have to select one set of numerical data instead of two in step one.

Step 1: Enter Data in Google Sheets.

This is the most important step because what you enter in your Google Sheets spreadsheet is what will be conveyed in your line graph.

Below is the entered data for the example above. Notice how cell A1 is empty.

Dataset for line chart

If you are creating a multiline graph, cell A1 will always be empty.

Step 2: Highlight the Data, and Click on the Chart Icon.

Select the entire dataset for which you want to insert the line chart and then click on the chart icon in the toolbar.

Click on the Chart Icon

You can also do the same by going to the Insert option on the menu and then clicking on the Chart option.

Click Insert and then click on chart icon

However, most of the time, Google will determine the entered data is appropriate for a line graph, and will automatically populate one for you so you dont have to select it.

In case it doesnt,

  • Click on the chart
  • Click on the three dots that appear on the top-right part of the chart,
  • Click on Edit chart

This will open the Chart editor pane on the right. You can change the chart type from the Chart type options (and select a line chart if that has not already been inserted)

Once you have the line chart in the worksheet, you can now fine-tune the chart using the Chart Editor.

Step 3: Choosing the Right Chart Type Settings

In the Chart editor, you get access to a number of Chart type setting options.

This first dropdown box under setup allows you to select the type of graph you want to use. The three options include:

  1. Regular Line chart
  2. Smooth line chart
  3. Combo line chart
Three types of line chart (1)

Heres how to do a line graph on Google Sheets with the different styles.

The image below is of a regular line chart

Regular line chart

The image below is of a smooth line chart

Smooth line chart

The image below is of a Combo line chart

Line chart and Column chart combo

A regular line graph will have a more jagged appearance, while a smooth line graph will have flowing lines. A combo line graph will combine a line graph with a bar graph. While the choice for how you want your graph to appear is yours, the most popular choice is the regular line graph as the data is displayed more directly and precisely.

Note that the combo line chart only makes sense when you have two series of data.

Below are some other options you have in the Chart setup pane:

  1. Data range: This is the range of cells you highlighted from your spreadsheet to create your chart.
  2. X-Axis: This is the range of cells from your spreadsheet that make up your charts X-Axis.
  3. Aggregate: When the aggregate box is checked, it allows you to aggregate all values that share an identical X-Axis key. For your series or lines, the aggregate dropdown box will give you the option of displaying the datas:
  4. Average
  5. Count
  6. Max
  7. Median
  8. Min
  9. Sum
  10. Series: Each line represented in your chart is called a series. The three dots at the end of the series bar give you the option to add labels or remove them.
  11. Switch Rows/Columns box: When checked, this will change your X-Axis data to the Y-Axis, and vice versa.
  12. Use Row 1 as Headers: By checking this box, youre using the labels from row one of your spreadsheets and creating a legend for your chart.
Chart Editor setup

Step 4: Doing Some Chart Customization

Now that you know how to create a line chart in Google Sheets, you should learn how to customize it. The Customize tab will allow you to change the:

  • Chart style
  • Chart and axis titles
  • Series
  • Legend
  • Horizontal Axis
  • Vertical Axis
  • Gridlines
Customizing the line chart

From font style to font size and from alignment to color, the customization tab truly allows you to make your chart your own.

Chart Style

A screenshot showing edited colors on a line graph

Under this section, youre given the opportunity to change the background color of your chart, as well as the charts border color and font. You can decide if you want your chart to have smooth lines, a maximized view, plotted null values, or a compare mode layout.

Chart & Axis Titles

adding a title with chart customization

Every chart needs a title so the audience knows what information theyre looking at. The chart and axis title section allows you to not only give your chart and each axis a title, but change the font style, font size, format, alignment, and color as well.

Series

showing an edited axis, legend, and line

Here you can customize the style of your lines. By adjusting each lines thickness, the marker point size, and the marker point shape, you can create the chart that most clearly displays the information you want to convey. In this section, the aggregate dropdown menu allows you to select the type of aggregate you want your chart to display. You can even customize a specific marker on your chart under format data point 🡪 add. You can even select to display features such as error bars, data labels, and trendlines.

Legend

This menu allows you to position your legend in your desired spot, as well as change the legends font, size, format, and text color. Read the full guide on how to label legends.

Horizontal Axis

Like the customization options above, the horizontal axis menu gives you the opportunity to change the label font, label font size, label format, and text color. Two boxes under this section also allow you to alter your chart by creating labels as text and reversing axis order.

Vertical Axis

Once again, with a choice of font, font size, format, and color, this menu option has two blank boxes to enter minimum and maximum values for the Y-Axis. You can check the box treat labels as text, as well as change the scale factor to include punctuation in your values. If you wish, you can customize the vertical axis by checking the log scale box, as well as changing the number format by selecting your desired style from the corresponding dropdown menu.

Gridlines

Gridlines can be helpful when displaying data. They provide a perspective that helps an audience better understand and comprehend the data provided. By selecting the major and minor gridline count, as well as the major and minor gridline colors, charts certainly come to life as does the data they display.

How to Make a Line Graph on Google Sheets FAQ

How Do You Make a Line Graph on Google Sheets?

To learn how to create a line graph in Google Sheets you just have to follow these easy steps:

  1. Highlight the data you wish to make a line graph from
  2. Click the chart icon in the tools menu or navigate to Insert > Chart
  3. In the Setup tab of the Chart editor change Chart type to Line chart
  4. Make any desired changes in the Customize tab

How Do You Make an XY Line Graph in Google Sheets?

To learn how to make line graph in Google Sheets of the XY variety you should use a scatter plot with a line of best fit instead of a line graph. To do so:

  1. Select Scatter chart in the Setup tab of the Chart editor
  2. Navigate to the Customize tab and click Series
  3. Check the Trendline box
Adding trendlines to a scatter chart

You could also refer to this method as learning how to make a linear graph in Google Sheets.

How Do You Make a Line Graph in Google Sheets With Two Sets of Data?

Learning how to make a line graph in Google Sheets with two or more sets of data is simple. You just have to make sure your two data sets share a comparable parameter for the Y axis. The old adage of you cant compare apples to oranges doesnt apply here. Lets take a look at an example:

Fruit sales example showing two line graphs

You can see that this example works because the Fruit Sales for each month can be plotted on the same graph. Yet, if you tried to plot the sales of apples against the seasonal ripeness of oranges you would have trouble.

The comparable data points can be different as long as they remain numerical and are properly labeled like in the example below that compares apple sales to orange picking rates.

Numerical Values to compare

You could also use a scatter plot with a trendline for similar purposes.

Lining up Your Next Graph

So this is how to make a line graph in Google Sheets. We hope this tutorial has helped you learn exactly how to make a line graph easily in any Google Sheet you may be working on. If you found this article useful, check out our other charting tutorials.

SumitSpreadsheet Expert at Productivity Spot | Website |+ posts

Google Sheets and Microsoft Excel Expert.

  • Sumithttps://productivityspot.com/author/sumitbansal23/How to Set Print Area in Google Sheets
  • Sumithttps://productivityspot.com/author/sumitbansal23/How to Split Text to Columns in Google Sheets (with Examples)
  • Sumithttps://productivityspot.com/author/sumitbansal23/How to Convert Time to Military Time Format in Google Sheets?
  • Sumithttps://productivityspot.com/author/sumitbansal23/Google Sheets Query Function: How to Use + Examples

You May Also Like the Following Tutorials:

Bar Sparkline in Google Sheets - rtl

Sparkline in Google Sheets  The Only Guide You Need

charts google sheets

Creating Candlestick Chart in Google Sheets (Step-by-step)

how to make a dot plot in google sheets

How to Make a Dot Plot in Google Sheets (Step by Step Guide)

How to Make a Pareto Chart in Google Sheets

The Pareto Chart Google Sheets Guide  3 Easy Steps

How to Highlight Duplicates In Google Sheets (Easy Steps)

How to Highlight Duplicates In Google Sheets (Easy Steps)

Google Sheets Conditional Formatting Based on Another Cell

Google Sheets Conditional Formatting Based on Another Cell

Using IF Function in Google Sheets (with Examples)

Using IF Function in Google Sheets (with Examples)

How to Create a Dependent Drop Down List in Google Sheets

How to Create a Dependent Drop Down List in Google Sheets

You may also like

Bar Sparkline in Google Sheets - rtl

Sparkline in Google Sheets  The Only Guide You Need

charts google sheets

Creating Candlestick Chart in Google Sheets (Step-by-step)

how to make a dot plot in google sheets

How to Make a Dot Plot in Google Sheets (Step by Step Guide)

How to Make a Pareto Chart in Google Sheets

The Pareto Chart Google Sheets Guide  3 Easy Steps

Video liên quan