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.
1
Click any cell in the Excel table.
2
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.
9
3
Right-click the Chart Title text box and click Edit Tex t . Enter Comparison for the
chart title.
4
On the Design tool tab, click the Change Chart Type button to open the Change
Chart Type dialog box.
5
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.
6
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.
7
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.
 
Search JabSto ::




Custom Search