Excel 2010 Bible

Part III: Creating Charts and Graphics

466

FIGURE 19.28

Changing the viewing angle to show different views of the same 3-D column chart.

Note
If anything other than a series is selected when you choose Chart Tools ➪ Design ➪ Type ➪ Change Chart
Type, all the series in the chart change. n

Figure 19.29 shows a column chart with two data series. The values for the Precipitation series are

very low — so low that they’re barely visible on the Value Axis scale. This is a good candidate for a

combination chart.

The following steps describe how to convert this chart into a combination chart (column and line)

that uses a second Value Axis.

1. Double-click the Precipitation data series to display the Format Data Series dialog
   box.


2. Click the Series Options tab and select the Secondary Axis option.


3. With the Precipitation data series still selected, choose Chart Tools ➪ Design ➪
   Type ➪ Change Chart Type.


4. In the Change Chart Type dialog box, select the Line type and click OK.