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

Method 1 – Use the Insert Tab to Make a Double Line Graph in Excel

Steps:

Select the cell range B4:D10.
From the Insert tab, choose Insert Line or Area Chart.
Select Line inside the 2-D Line section.

How to Make a Double Line Graph in Excel 2

This will provide a basic double-line graph.

How to Make a Double Line Graph in Excel 3

Select the Line Chart, and from the Chart Elements, deselect Gridlines.

How to Make a Double Line Graph in Excel 4

Double-click on the Vertical Axis of the Chart.

How to Make a Double Line Graph in Excel 5

Open the Format Axis box.
Set the Minimum Bounds to 105 under the Axis Options section.

How to Make a Double Line Graph in Excel 6

Here’s the modified graph.

How to Make a Double Line Graph in Excel 7

Method 2 – Adding a Second Line Graph to an Existing Chart to Make a Double Line Graph

Steps:

Select a single-line graph.

How to Make a Double Line Graph in Excel 8

From the Chart Design tab, click on “Select Data”.

How to Make a Double Line Graph in Excel 9

The Select Data Source dialog box will open.
Press Add.

How to Make a Double Line Graph in Excel 10

Select cell D4 as the “Series name”.
Select the cell range D5:D10 as the “Series values”.
Press OK.

How to Make a Double Line Graph in Excel 11

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

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

Our dataset is in the “VBA” Worksheet.

VBA

Steps:

Press Alt + F11 to bring up the VBA window, or select Visual Basic from the Developer tab.

Insert Module

From Insert, select Module.

VBA Module

Insert the following code in the module.

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

We are calling our Sub procedure Make_Double_Line_Graph.
We insert a Chart in the Active Sheet.
We use the VBA With statement to set the properties of the Chart.
We make the Gridlines from the graph disappear and move Legend at the bottom.
This code works to create a double-line graph.