➤ Go to Insert > Insert Line > Select any line graph. Likewise, in Step 1, we will do the same thing. ➤ Finally, the Age graph is now in the graph box. ➤ Lastly, the Select Data Source window will again show up. And we can see in the Axis label take the range from Month. ➤ At the present time, go to Edit from the Horizontal(Category) Axis Labels. We already take the value from the age column, now we are giving the name Age. One is Series Name another is Series Value.

➤ As we can see in the window contains two sectors. ➤ Then, the Edit Series window will pop up. Now, select the Age column. ➤ Click on the upper arrow on the series values. This will open up the Edit Series window. ➤ Next, click on ADD to add the data from the excel workbook.

➤ After that, we can see the Select Data Source window will show up. ➤ In the beginning, right-click on the graph box. Let’s do the first one, and we want to show the Age graph here. After that, select the line as per requirement, we select the first one. Secondly, from the insert tab go to Insert Line. ➤ Firstly, go to the Insert tab in the ribbon. Related Content: How to Combine Sheets in Excel (6 Easiest Ways)Įxcel lets us combine two or more different graph types to make it easier to display related information together.

We will combine the age and total sale graph. Now, we will see the age and total sales of the months in just one graph. 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. For this, we are going to use the dataset below. So, let’s take a look at step-by-step instructions to combine graphs in excel. Occasionally, we need to combine graphs for working purposes. To communicate data graphically, we use Excel graphs.

Excel graph axis label month