Microsoft Office Tutorials and References
In Depth Information
Tip 88: Creating a Combination Chart
Creating a Combination Chart
A combination chart combines two chart types in a single chart. A combination chart may use a
secondary vertical axis. In the past, creating a combination chart in Excel was relatively complicated and
required some non-intuitive steps. Excel 2013 finally gets it right: creating a combination chart is easy.
Figure 88-1 shows a column chart with two data series: Temperature and Precipitation. Because
these two measures have drastically different scales, the columns for the precipitation data are hardly
visible. This is a good candidate for a combination chart.
Figure 88-1: The two data series in this chart use drastically different scales.
Inserting a preconfigured combination chart
The following steps describe how to create a combination chart from the data in range A2:M4. The
chart will display temperature as columns, and precipitation as a line. In addition, the precipitation
series will use a secondary vertical axis.
1. Select the range A2:M4.
2. Choose Insert ➜ Charts ➜ Combo.
This command expands to display three icons (see Figure 88-2). Hover your mouse over the
icons, and you’ll see a preview.