Exam 77-427 Microsoft Excel 2013 EXPERT
4. Create Advanced Charts and Tables
4.1   Create Advanced Chart Elements: Create Dual Axis Charts

 

Change Series Type

Hold on, hold on. There are two Series, one on top of the other. Please change the Hourly Wage from a Column Chart to a Line. Then, you will be able to see both data sets in the chart.

6. Try it: Change the Chart Type

Select the Salary Chart.

Go to Chart Tools -> Format.

Go to Current Selection.
Select Series "Hourly Wage".

Go to Chart Tools -> Design-> Type.

Click on Change Chart Type.

This time, you should see Custom Combination.

The Salary should be a Clustered Column.
The Hourly Wage should be a Line Chart.

 

Click OK. Did it work? Let's see...

graphic2
graphic1
Chart Tools -> Design-> Type-> Change Chart Type