Change Series Type

Hold on, hold on. There are two Series, one on top of the other. Please change the Wages 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.

Choose a Line Chart.

 

Very good. You can SAVE if you wish.

That's enough for now. You get the cookie.

Exam 77-888: Microsoft Excel Expert 2010

3. Presenting Data Visually

3.1. Apply advanced chart features: Modify Dual Axes

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