How to Combine Graphs in Excel (Step-by-Step Guideline)

To build data visualizations, Excel graphs are useful. A graph, rather than a table with rows of numbers, can provide a clearer image of a collection of data values, allowing managers to apply this insight into the analysis and future planning. Sometimes, we need to combine two or more graphs in excel. In this article, we will look at how excel combines graphs.


Download Practice Workbook

You can download the workbook and practice with them.


Steps to Combine Graphs in Excel

To communicate data graphically, we use Excel graphs. Occasionally, we need to combine graphs for working purposes. So, let’s take a look at step-by-step instructions to combine graphs in excel. For this, we are going to use the dataset below. The dataset contains months in column B, the employee names in column C, all the employee’s ages in column D, and the total sale of each employee in the mentioned months. Now, we will see the age and total sales of the months in just one graph. We will combine the age and total sale graph. Let’s see how we can combine them.

Steps to Combine Graphs in Excel

Related Content: How to Combine Sheets in Excel (6 Easiest Ways)


Step 1: Insert a Line Graph

Excel lets us combine two or more different graph types to make it easier to display related information together.

➤ Firstly, go to the Insert tab in the ribbon. Secondly, from the insert tab go to Insert Line. After that, select the line as per requirement, we select the first one.

Steps to Combine Graphs in Excel

➤ This opens the graph box.Steps to Combine Graphs in Excel


Step 2: Selecting Data to Draw the Graph

Let’s do the first one, and we want to show the Age graph here.

➤ In the beginning, right-click on the graph box. Then, click on the Select Data.

➤ After that, we can see the Select Data Source window will show up.
➤ Next, click on ADD to add the data from the excel workbook. This will open up the Edit Series window.

Steps to Combine Graphs in Excel

➤ Click on the upper arrow on the series values.

➤ Then, the Edit Series window will pop up. Now, select the Age column. Hit Enter.

Steps to Combine Graphs in Excel

➤ As we can see in the window contains two sectors. One is Series Name another is Series Value. We already take the value from the age column, now we are giving the name Age. Then, click on the Ok button.

➤ At the present time, go to Edit from the Horizontal(Category) Axis Labels.

Steps to Combine Graphs in Excel

➤ At this time, select the Month column. And we can see in the Axis label take the range from Month. And, now hit Enter.

➤ Now, click OK.

➤ Lastly, the Select Data Source window will again show up. So, click on OK.

➤ Finally, the Age graph is now in the graph box.

Steps to Combine Graphs in Excel


Step 3: Place Another Line Graph

Likewise, in Step 1, we will do the same thing.

➤ Go to Insert > Insert Line > Select any line graph.

Steps to Combine Graphs in Excel

➤ A graph box will expose.

Steps to Combine Graphs in Excel


Step 4: Take Different Data to Draw Another Graph

Correspondingly Step 2, we shall proceed in the same manner.

➤ First, right-click on the graph and go to Select Data.

➤ Following that, we could see a window name Select Data Source. Now, we want to add the data. for this, we are clicking on ADD. This will appear in the Edit Series window.

Steps to Combine Graphs in Excel

➤ Click the top arrow on the series values in the Edit Series box.

➤ After that, in column E. Select the data from the Total Sale and press Enter.

➤ Give a name of the Series Name, we are giving Total Sale. Then, press the OK button.

Steps to Combine Graphs in Excel

➤ Finally, there we go. Now, we can see the two graphs in our worksheet.

Steps to Combine Graphs in Excel


Step 5: Copy and Paste the Line to Combine Graphs in Excel

➤ Now is the final step. Put your mouse pointer over the graph and click on the graph.

Copy and Paste the Line to Combine Graphs in Excel

➤ Go to Home tab > click on Copy.

➤ Now, keep the mouse pointer on the first graph. And, select the graph box.

Copy and Paste the Line to Combine Graphs in Excel

➤ In the end, paste the graph on the first graph.

Copy and Paste the Line to Combine Graphs in Excel

Related Content: How to Combine Rows in Excel (6 Methods)


Final Output of the Combined Graph in Excel

Now, we can see the final output of those steps above. The two graphs are now combined.

Excel Combine Graphs


Conclusion

Hope this will help you! If you have any questions, suggestions, or feedback please let us know in the comment section. Or you can have a glance at our other articles in the ExcelDemy.com blog!


Related Articles

Sabrina Ayon

Sabrina Ayon

Hi there! This is Sabrina Ayon. I'm really excited to welcome you to my profile. Currently, I'm working in SOFTEKO as a Excel and VBA Content Developer. I'm a student of United International University and my program is Computer Science and Engineering. I love working with computers and solving problems. I’ve always been interested in research and development. So, here I will be posting articles related to Microsoft Excel. Hoped this may help you. Thank you.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo