Introduction

In this lesson you will learn how to graph two lines in Excel, using a scatter plot.

It is often helpful to graph more than one set of data on the same chart. This helps you better compare the two sets of data. Excel can help you do this.

This video illustrates the lesson material below. Watching the video is optional.

• Graphing Two Lines Using a Scatter Plot with Connected Lines (05:58 mins) | Transcript

Setting Up Data

The first thing you will do is make a table in Excel.

• The first column will hold the values of the independent variable (usually the x-axis values).
• Put the corresponding dependent variable (y-axis) values in additional columns.

Be sure to include labels for the columns.

Figure 1

An independent variable is a variable that can stand by itself and isn’t changed by other variables. Notice in the picture above, the Year column holds the independent variable.

Data 1 and Data 2 are the dependent variables. If there was not a year to measure against, the data would not exist. The dependent variable can sometimes be referred to as the outcome variable.

Creating the Chart

There are a series of steps that must be followed when creating a scatter plot.

1. Highlight all the data you would like to plot, including the column titles.
2. Go to the Insert tab.
3. Find the Charts section and select Scatter.
4. Select one of the scatter plot icons that connects the dots with a line.

Figure 2

Edit ranges, axis titles, chart titles, and anything else you want to adjust. You can do this by doing the following:

1. Select the chart
2. Select the Chart menu
3. Select the desired elements in the Labels and Axes groups.

Figure 3

Feel free to explore different settings; this is the best way to familiarize yourself with the program.

Things to Remember

• To make a scatter plot you must have an independent variable and a dependent variable.