

Please note that the steps we are going to be covering in this example are for Excel 2013 and newer versions. You can download our sample workbook here. Bar and Radar: The third combination from the example above shows how two irrelevant chart types can result in visualization that is hard to read.We typically recommend not using more than 2 types of charts to avoid congestion.


In this example, we’re going to be using 3 variations. Legend: The legend is an indicator that helps distinguish the data series.įeature several possible combinations, combo charts can come in various types.Note: This is an optional feature, however a secondary axis is commonly used in combo charts. Secondary Vertical Axis: The vertical axis on the right that represents the measured values of the secondary datasets, also known as the secondary y-axis.Note: If one of the datasets is plotted on a bar chart, the vertical axis shows the categories instead of the values. Primary Vertical Axis: The vertical axis on the left that represents the measured values, also known as the primary y-axis.Note: If one of the datasets is plotted on a bar chart, the horizontal axis shows the values instead of the categories. The data series can be used as groups, as shown in the sample chart above. Horizontal Axis: The axis that contains the categories of the data, also known as the x-axis.Giving your chart a descriptive name will help your users easily understand the visualization. Plot Area: This is where the visual representation takes place.In this article, we're going to show you how to add a secondary axis in Excel.Ī combo chart mainly consists of 6 sections. A combination chart can visualize both values in a single chart area by using a secondary axis. revenue $150,000) with traditional charts. conversion rate of 1.2%) cannot be shown efficiently if a set of values contain more than 1 or 2 digits (i.e. For example, values at a percentage scale (i.e. This combination of charts is especially useful for visualizing different data sets side-by-side. A combination chart (also known as a combo chart) is a graphic representation of multiple data sets demonstrated with the use of different types of charts.
