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.
- 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.
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.
Download Practice Workbook
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!