Select the Data

Here are the steps to add a second Series to the Chart.

3. Try it: Select the Data

Select the Salary Chart

Go to Chart Tools -> Design-> Data.

Click on Select Data.

What Do You See? You will be prompted to edit the Chart Data range. You can use the lookup button to highlight A1:C4.

 

What Else Do You See? When you selected Column C, Excel added a second Series for the Hourly Wage.

 

Click OK and keep going...

Exam 77-888: Microsoft Excel Expert 2010

3. Presenting Data Visually

3.1. Apply advanced chart features: Add a Second Series

Chart Tools -> Design-> Data-> Select Data