Microsoft Office Tutorials and References
In Depth Information
Creating Combination Charts
You can search the Excel Ribbon all day, and you won’t find a command to create a combination
chart. If you already created your chart (that has at least two data series), you can easily convert
it to a combination chart. Follow these steps:
1. Click the series that you want to change.
2. Choose Chart Tools
Change Chart Type.
3. In the Change Chart Type dialog box, choose the icon that represents the chart type for
the selected series.
4. If you’d like to use a second vertical axis for the converted series, select the series and
press Ctrl+1 to display the Format Data Series dialog box; click the Series Options tab and
select Secondary Axis.
The chart in Figure 136-1 started out as a standard column chart with two series. A few mouse
clicks later, one of the series (named Precipitation, in this case) is converted from columns to a
line. I also added a secondary axis and labeled the axes to make it perfectly clear which scale is
used for which series. To add axis titles, use Chart Tools
Figure 136-3 shows another combination chart. This chart combines a column chart and a line
chart, and both series use the same vertical axis. In this case, depicting the monthly sales goal as
a line chart makes it easier to identify the months in which the goal was met.
Figure 136-3: A combination chart that uses a single vertical axis.
Figure 136-4 shows how far you can go with a combination chart. This chart combines five
different chart types: Pie, Area, Column, Line, and XY. I can’t think of any situation that would warrant
such a chart, but it’s an interesting demo.