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

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.

Make a Double Line Graph in Excel: 3 Handy Approaches

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.

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.

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

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

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

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

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

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

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.

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

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

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

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

Read More: How to Plot Multiple Lines in One Graph in Excel

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 “VBA” Worksheet.

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.

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

• 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

• Afterward, Save the Module.
• Then, put the cursor inside the first Sub procedure and press Run.

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

Practice Section

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

Download Practice Workbook

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. Thanks for reading, keep excelling!

Related Articles

• How to Combine Two Line Graphs in Excel
• How to Combine Two Bar Graphs in Excel
• How to Combine Bar and Line Graph in Excel
• How to Edit a Line Graph in Excel
• How to Overlay Line Graphs in Excel
• Line Graph in Excel Not Working

<< Go Back To Line Graph in Excel | Excel Charts | Learn Excel