Microsoft Office Tutorials and References
In Depth Information
Creating dual-axis charts
IMPORTANT Dual-axis charts that plot series with widely separated values can be visually
deceiving. Be sure to read them carefully.
In this exercise, you’ll create a dual-axis chart.
SET UP You need the DualAnalysis workbook located in the Chapter09 practice file
folder to complete this exercise. Open the workbook, and then follow the steps.
Click any cell in the Excel table.
Click the Insert tab and then, in the Charts group, click the Insert Column Chart
button and click the first 2D Column chart subtype, Clustered Column . When you
do, Excel creates a chart with the two data series.
Right-click the Chart Title text box and click Edit Tex t . Enter Comparison for the
On the Design tool tab, click the Change Chart Type button to open the Change
Chart Type dialog box.
If necessary, click the All Charts tab to display that page of the dialog box. Then, in
the list of chart types, click Combo to display the Combo Chart interface.
Verify that the Volume series will be plotted by using a Clustered Column chart and
that the Exceptions series will be plotted by using a Line chart.
Select the Secondary Axis check box next to the Exceptions series. Doing so adds a
second vertical axis to the right edge of the chart. The values on this axis reflect the
values in the Exceptions series.