Switch to the Charts tab of the Excel ribbon and select a chart type from the Insert Chart group. Most combination charts meld together a column or bar chart with a line chart. Step 4 Click on one. If your data is in a table then select insert chart and recommended charts. If your data is a good fit for line charts it will be a recommendation in 2016, otherwise select line chart from the left. Aug 09, 2016 Select Series Data: Right click the chart and choose Select Data, or click on Select Data in the ribbon, to bring up the Select Data Source dialog.You can't edit the Chart Data Range to include multiple blocks of data. However, you can add data by clicking the Add button above the list of series (which includes just the first series). On the second worksheet, select a column or a row of data you want to add to your Excel graph, and then click the Expand Dialog icon to get back to the full-sized Edit Series window. And now, click the Collapse Dialog button to the right of the Series name field and select a cell containing the text you want to use for the series name.
A combination chart is a chart that combines two or more chart types in a single chart.
To create a combination chart, execute the following steps.
1. Select the range A1:C13.
2. On the Insert tab, in the Charts group, click the Combo symbol.
3. Click Create Custom Combo Chart.
The Insert Chart dialog box appears.
4. For the Rainy Days series, choose Clustered Column as the chart type.
Combine Two Graphs On Excel
Combine Two Column Graphs Excel
5. For the Profit series, choose Line as the chart type.
6. Plot the Profit series on the secondary axis.
The Insert Chart dialog box appears.
4. For the Rainy Days series, choose Clustered Column as the chart type.
Combine Two Graphs On Excel
Combine Two Column Graphs Excel
5. For the Profit series, choose Line as the chart type.
6. Plot the Profit series on the secondary axis.
7. Click OK.
Result:
