Tip 88: 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.
...