How to Make Line Graph in Excel with 2 Variables (With Quick Steps)

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.

How to Make Line Graph in Excel with 2 Variables

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.

How to Make Line Graph in Excel with 2 Variables

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.

How to Make Line Graph in Excel with 2 Variables

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

How to Make Line Graph in Excel with 2 Variables

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

How to Make 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.

Customize Line Graph in Excel

  • 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.

Customize Line Graph in Excel

  • 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.

Customize Line Graph in Excel

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

Customize Line Graph in Excel

  • 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.


Related Articles

Guria

Guria

Hello! Welcome to my blog. I have completed my Bachelor in Architecture from Ashanullah University of Science & Technology, Dhaka. I am a passionate, goal-oriented person with an immense thirst for knowledge and an attitude to grow continuously. Besides Architectural work, I find it very enthusiastic to work in Excel blogging. Exceldemy is a platform where I have got the opportunity to flourish my skill in Microsoft Excel and therefore, here I will be posting blogs related to it.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo