So When Should You Use the Combo chart in Excel? And the bars should be in the background. If using a Line and Bar Combo visualization, then the lines should be in the foreground.This chart can only display one hierarchy at a time.įor example, if the first cell selected is a quarterly value, other periods, such as monthly and annual values, will be excluded - only quarterly values will be displayed.You can use lines and bars in a single chart to display insights into the relationship between varying variables.Similarly, data points on the secondary (right) side of the chart define the scale for the y-axis.Variables on the primary (left) side of a Combo Chart define the scale for that y-axis.The General Structure of a Combination Chart in ExcelĬheck out the key components of the Combo chart in Excel (below). You can also use this chart to display insights into hidden patterns, trends, and outliers in your raw data. Use Combo chart in Excel if your objective is to validate the relationship between two variables with different magnitudes and scales but related in context.įor example, you can use a Combination Chart in Excel to display insights into different sales metrics that share a common denominator, i.e., the financial year.

In this blog post, we’ll primarily talk about the Double Axis Line and Bar Chart (a Combo chart in Excel variant). There’s a wider variety of Combination Charts in Excel you can use for your data stories, namely: Besides, it forms the basis of data visualization designs, such as the Pareto or 80/20 visualization.

The Combo visualization design provides you with a flexible way of displaying data.

What are the trends for the same categories in data? This chart can help you answer questions about your data, such as: You can make a Combo Chart with data that share a common string, such as a financial year. What is a Combo Chart in Excel?Ī Combo Chart combines Column and Line Charts.

How to Create a Combo Chart in Excel in Data Storytellingīefore we dive right into the how-to guide, let’s define the chart we’ll be talking about throughout the blog post.

Create combo box in excel