Step 1:- First, select the data table prepared, then go to the insert tab in the ribbon, click on Combo, and then select clustered column – line. This example explains an alternate approach to arrive at a combination chart in Excel. Now choose a required style for the chart from the Design tab.īelow is the completed chart for this example:-Ĭombination Charts (Combo) in Excel Example #2Ĭonsider the below table consisting of region-wise profit and margin data. To change the background for the charts, click on the chart so that the “Design” and “Format” tab in the ribbon will appear, as shown in the red rectangle.

To change the name, click on the “Chart title” and rename the chart to the required title, as shown in the below screenshot.Once the selections are made, click, OK.As can be seen in the below screenshot, the profit and expense parameters are changed to stacked bar charts, and headcount is selected as a line chart in the secondary y-axis. In the Change Chart Type window, select the data table parameters to be plotted on the secondary y-axis by clicking the box by a tick mark.įor the current example, profit and expenses (as they are in dollar value) are considered to be plotted in the primary y-axis, and the headcount will be plotted in the secondary y-axis.If the chart needs to be changed to a different chart, then right-click on the graphs and select “Change Chart Type,” as shown in the below screenshot.Once the clustered chart is selected, the combo chart would be ready for display and illustration.Now select the clustered Column excel chart in the options provided in the combo charts dropdown.As shown in the below screenshot, select the data table, then go to the insert tab in the ribbon and select combo charts as shown in the red rectangle and right arrow.Select the entire table to be plotted on the chart.Typically the new feature for combo charts in Excel is now available from 2013 and later versions.īelow are the examples of the Combination Chart in Excel (Combo). The combination charts in Excel are also called as combo charts in the newer version of excel.Combo Chart in excel is the best feature that enables a user to summarize large data sets with multiple data tables and illustrate the numbers in a systematic manner in one chart.The combination charts in excel give a comparative analysis of the two graphs of different categories and also for the mixed type of data, thereby enabling the user to view and highlight higher and lower values within the charts.

What is a Combination (Combo) Chart in Excel?Ĭombination charts in Excel let you represent two different data tables that are related to each other, in which there would be a primary x-axis and y-axis and an additional secondary y-axis to help provide broader understanding in one chart. Combination chart or most commonly known as combo chart in excel is a combination of two or more than two different charts in excel, to make such types of combo charts we can use the option of creating a combo chart from the insert menu in the chart tab also in order to combine two charts we must have two different data sets but one common field to combine.

How to combine histogram in excel 2016