Excel Combination Chart Series Data And

As it is a nice way to do so and gives a quick analytical overview of the data.

However, have you faced any such scenarios where you have to use a combination of two charts (for example, bar chart and line chart) in a single graph to give a more crisp idea about the data I bet you must have come with such scenarios.

Combining two or more charts in a graph is not an easy task, but we will make it so throughout this article and assure you that, you will be able to do it by your own with ease once you go through this article.

It allows you to represent two different datasets (which are related to each other) on the same chart.

Excel Combination Chart Series Data And

In the usual chart, we have two axis X-axis and Y-axis where on Y-axis you have series data and on X-axis you have categories.

However, when you use a combination chart, youll have two series or in other words two Y-axis for the same X-axis or categories.

Following are the Sales, Margin and Margin values from January to August (Year 2019) for all the products we sold.

Navigate to Insert Tab and under Charts section, click on Column or Bar Chart icon.

However, we wanted this to be for all the users (Some Excel users using older version might not have the recommended charts option), we are showing it step by step.

Rightly so, because they have values really very small in comparison to that off Sales and Margin values.

However, we wanted to make the Margin visible to management as well.

So that they will have a better understanding of movements happening.

Follow the steps as below to create a combination of two charts.

Most of the times, it will be selected by default for you by system, using its own intelligence.

Out of those select the second option which is Clustered Column Line on Secondary Axis chart.

This option of the chart enables the secondary axis visible on the right- hand side of the graph.

Because it is now added as separate series values (remember the secondary Y-axis on the right-hand side of the graph).

As the series values have been plotted on a separate axis, they are now not relevant to the values of primary series values (Y-axis).

Therefore, they can now be seen more precisely and visually as well as technically more relevant.

However, at the same time, it might confuse the user due to complexity which gets added due to the combination.

So that they can have better visualization for two different values for the same categories.

Here we discuss How to create Combo Chart in excel along with practical examples and downloadable excel template.

By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy.

Excel For Mac Combination Chart