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.
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.
- 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.
- Add a Vertical Dotted Line in Excel Graph (3 Easy Methods)
- Draw Target Line in Excel Graph (with Easy Steps)
- How to Draw a Horizontal Line in Excel Graph (2 Easy Ways)
- How to Combine Bar and Line Graph in Excel (2 Suitable Ways)
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.
- 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.
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.
- 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
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.
- So, our code will execute and it will create a double line graph.
We have added a practice dataset for each method in the Excel file. Therefore, you can follow along with our methods easily.
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!