Sabrina Ayon
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.
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!
