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.

**Table of Contents**hide

**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.

**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.

➤ This opens the graph box.

**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.

➤ Click on the upper arrow on the series values.

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

➤ 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**.

➤ 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.

**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.

➤ A graph box will expose.

**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.

➤ 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.

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

**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.

➤ Go to **Home** tab > click on **Copy**.

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

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

**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.

**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!