How to Make a Double Line Graph in Excel (3 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

We are going to show you 3 easy methods to make a double line graph in Excel. Line graphs are useful to visualize changes over a short period of time. Additionally, when the changes are not huge, line graphs are more useful than other types of graphs.


Download Practice Workbook


3 Handy Approaches to Make a Double Line Graph in Excel

To demonstrate our methods, we have selected a dataset consisting of 3 columns: “Name”, “Weight 2020 (lbs)”, and “Weight 2021 (lbs)”. Basically, we are comparing 6 employees’ average weight over 2 years. Then, using these data, we will create a double line graph. Moreover, we have attached the double line graph and we will learn how to make this graph using 3 easy methods.

How to Make a Double Line Graph in Excel


1. Inserting Charts Command to Make a Double Line Graph in Excel

First, we just select the data, and then, using the Insert Charts command, we will create a double line graph in Excel.

Steps:

  • To begin with, select the cell range B4:D10.
  • Next, from the Insert tab >>> Insert Line or Area Chart >>> select Line, inside the 2-D Line section.

How to Make a Double Line Graph in Excel 2

  • After that, we will get a basic double line graph.

How to Make a Double Line Graph in Excel 3

  • Then, we will edit the Chart.
  • So, select the Line Chart and from the Chart Elements, deselect Gridlines.

How to Make a Double Line Graph in Excel 4

  • Afterward, double-click on the Vertical Axis of the Chart.

How to Make a Double Line Graph in Excel 5

  • Therefore, this will make the Format Axis box appear.
  • Then, set the Minimum Bounds as 105 under the Axis Options section.

How to Make a Double Line Graph in Excel 6

  • Finally, it will modify the double line graph like this.

How to Make a Double Line Graph in Excel 7

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


Similar Readings


2. Adding Second Line Graph to Existing Chart to Make a Double Line Graph

In this section, we will add a line graph to an existing line graph to make a double line graph.

Steps:

  • Firstly, select the single-line graph.

How to Make a Double Line Graph in Excel 8

  • Next, from the Chart Design tab, click on “Select Data”.

How to Make a Double Line Graph in Excel 9

  • So, the Select Data Source dialog box will pop up.
  • Then, press Add.

How to Make a Double Line Graph in Excel 10

  • Afterward, select cell D4 as the “Series name”.
  • Then, select the cell range D5:D10 as the “Series values”.
  • Lastly, press OK.

How to Make a Double Line Graph in Excel 11

  • Therefore, it will insert another line graph into the original graph and the output graph will be similar to this.

How to Make a Double Line Graph in Excel 12

Read More: How to Make a Single Line Graph in Excel (A Short Way)


3. Applying VBA Code to Make a Double Line Graph in Excel

For the last method, we are going to apply an Excel VBA Macro to construct a double line graph in Excel. Moreover, we can see that our dataset is in the “VBAWorksheet.

VBA

Steps:

  • To begin with, press ALT+F11 to bring up the VBA window.
  • Alternatively, we can do it by selecting Visual Basic from the Developer tab.

Insert Module

  • Then, from Insert >>> select Module. We’ll type our code here.

VBA Module

  • Then, type the following code.
Sub Make_Double_Line_Graph()
Application.ScreenUpdating = False
ActiveSheet.Shapes.AddChart.Select
With ActiveChart
    .SetSourceData Source:=Range("'VBA'!$B$4:$D$10")
    .ChartType = xlLine
    .Axes(xlValue).MinimumScale = 105
    .HasTitle = True
    .ChartTitle.Text = "VBA Double Line Graph"
    .SetElement (msoElementPrimaryValueGridLinesNone)
    .SetElement (msoElementLegendBottom)
End With
Application.ScreenUpdating = True
End Sub

VBA Code

VBA Code Breakdown

  • First, we are calling our Sub procedure  Make_Double_Line_Graph.
  • Next, we insert a Chart in the Active Sheet.
  • Then, we use the VBA With statement to set the properties of the Chart.
  • Afterward, we make the Gridlines from the graph disappear and move Legend at the bottom.
  • Thus, this code works to create a double line graph.
  • Afterward, Save the Module.
  • Then, put the cursor inside the first Sub procedure and press Run.

VBA Code Run

  • So, our code will execute and it will create a double line graph.

VBA Code Output

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


Practice Section

We have added a practice dataset for each method in the Excel file. Therefore, you can follow along with our methods easily.

Practice Dataset


Conclusion

We have shown you 3 handy approaches to how to make a double line graph in Excel. If you face any problems regarding these methods or have any feedback for me, feel free to comment below. Moreover, you can visit our site ExcelDemy for more Excel-related articles. Thanks for reading, keep excelling!


Related Articles

Rafiul Haq

Rafiul Haq

Hello! This is Rafiul. I have an engineering degree and an MBA (finance) degree. I am passionate about all things related to data, and MS Excel is my favorite application. I want to make people's lives easier by writing easy-to-follow and in-depth Excel and finance related guides here at ExcelDemy.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo