Working with Dual Axis

Say you wanted to compare salary and hourly wages. The two data sets have vastly different scales. Salary is measured in thousands per year. Wages would be dollars per hour.

 

You can add more than one axis when you work with two dimensional (2D) charts.

1. Try it: Change the Chart Type

Select the Salary Chart.

Go Chart Tools -> Design-> Type.

Click on Change Chart Type.

Select: 2D Column.

Click OK. Keep going...

Chart Tools -> Design-> Type-> Change Chart Type

Exam 77-888: Microsoft Excel Expert 2010

3. Presenting Data Visually

3.1. Apply advanced chart features