Part III: Creating Charts and Other Visualizations
The following steps describe how to convert this chart into a combination chart (column
and line) that uses a second value axis:
- Activate the chart, and choose Chart Tools ➪ Design ➪ Type ➪ Change Chart
type. The Change Chart Type dialog box appears.
- Select the All Charts tab.
- In the list of chart types, click Combo.
- For the Avg Temp series, specify Clustered Column as the chart type.
- For the Precipitation series, specify Line as the chart type and click the
Secondary Axis check box.
- Click OK to insert the chart.
Figure 21.29 shows the Change Chart dialog box after specifying the parameters for each
series.
FIGURE 21.29
Using the Change Chart dialog box to convert a chart into a combination chart
