pic1

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

Plot Series on Secondary Axis

Now that the Series is selected you can format the Secondary Axis. Here are the steps.

5. Try it: Edit the Series Options

Go to Chart Tools -> Format.

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

Click on Format Selection.


What Do You See? The Format Data Series options will open on the right side.

Go to Series Options->Plot Series On.
Select: Secondary Axis.

 

Click OK.

Please keep going...

graphic2
graphic1
Chart Tools -> Format-> Current Selection