One of the most efficient tools for visualizing data in excel is the** line graph**. It helps to demonstrate various datasets in a simple form which allows the audience to understand the information more clearly than typical number tables. Let’s get to know the line graph a little more and learn how to make a line graph in excel with 2 variables in quick steps.

## Download Workbook

Get the sample workbook here for practice.

## Line Graph (Charts) in Excel

In easy words, the line graph is the method to visualize data through straight lines connecting data points. It consists of two axis. The horizontal axis or X-axis holds the independent data, mostly the time period which is constant. On the other hand, the vertical axis or Y-axis represents variable data. A line graph can also illustrate negative values by dropping the line down through the horizontal axis. In a nutshell, the line graph is the visual representation of the quantitative dataset.

## Step by Step Guidelines to Make Line Graph in Excel with 2 Variables

Now we will make a line graph in excel with 2 variables. Just follow the step-by-step guidelines below:

### Step 1: Prepare Dataset

The first and foremost thing to create a line graph is to prepare a proper dataset. For example, we have prepared a dataset of a company’s sales and profit in the first half of a year.

**Insert**the**time period**on**column B**as it is the**independent data**that are fixed.- In
**columns****C**and**D**, place the data that is**variable**.

**Read More: ****How to Make a Line Graph in Excel with Two Sets of Data**

### Step 2: Select Data to Make Line Graph

- At this step
**select**the whole**dataset**that you want to include in the line graph.

**Read More: ****How to Make Line Graph with 3 Variables in Excel (with Detailed Steps)**

### Step 3: Create Line Graph in Excel

- Now, go to the
**Insert tab**from the ribbon in excel. **Click**on**Line Chart**from the**Charts**section.

- After this, you will see a
**drop-down**section with multiple options of line graphs to choose from.**Select**any one of your preferences.

- That’s it, we completed our task to make a
**Line Graph**in excel with 2 variables.

- Don’t forget to name your line graph after this.

**Read More: ****How to Make a Line Graph in Excel with Multiple Variables**

## Customize Line Graph in Excel

So as we have our line graph now, we can explore different options to customize it. Let’s have a quick look at the features to edit and ornament the line graph in excel.

### 1. Add Chart Element

**Chart Element **helps to define the** Line Graph **more accurately with gridlines, bars, axes etc. Let’s see how to use this component.

- First,
**select**the**line graph**and it will result in opening a new**Chart Design**tab. - After that,
**click**on the**Add Chart Element**.

- Then,
**select**any of the options from the**drop-down**section.

- Another way is to
**click**on the**Chart Element**icon beside the**Line Graph**to select any chart element.

**Read More: ****How to Make a Double Line Graph in Excel (3 Easy Ways)**

### 2. Change Style and Color

You can decorate the** Line Graph** with a variety of colors and chart styles from this section.

- From the
**Chart Design**tab, you can change the color and line graph style from the**Chart Styles**section.

- You can also find the same feature on the right side of the graph.

### 3. Edit Data in Line Graph

This tool will help you to make any modification in the dataset even after completing a whole **Line Graph**.

- First,
**click**on**Select Data**from the**Chart Design**tab.

- After that, It will open a new window called
**Select Data Source**.

- From here, you can edit data however it is required.

- Another way is to
**select**the**filter icon**on the right side of the line graph and edit it the way you need.

- There are endless options to customize your dataset apart from the above features. Give it a try and explore.

**Read More: ****How to Make a Line Graph in Excel with Multiple Lines (4 Easy Ways)**

## Advantages of Line Graph in Excel

**Line Graph**is a clean and neat tool to represent your dataset.- It makes it easier to visualize multiple sets of data at the same time.
- It makes relevant information compact and clear to its viewers.

## Things to Remember

- It is better to avoid the
**Line Graph**if you are working on a large dataset because it will create confusing graph formation. - A
**line graph**is not suitable for data with percentages. Instead of that, you can use Chart. - Make your dataset without any blank. Otherwise, Excel will not create any
**Line Graph**for missing data.

## Conclusion

In the end, we hope that it was a helpful article for you to learn how to make a line graph in excel with 2 variables. We also tried to benefit you with some additional editing features. Download the practice workbook and try it on your own.