Select the Data
The Salary Chart uses A1:B4. The new Range will include the data in C1:C4.
3. Try it: Select the Data
Select the
Chart, first.
Go to
Chart Tools -> Design-> Data.
Click on
Select Data.
What Do You See? There is one Series on this Chart: Salary. The Category includes the Axis Labels. This is the data from Column A.
So, Try This: Add Another Series
Click on Chart Data Range.
Select the Chart Data
range: A1:C4.
What Do You See? After you select A1:C4, Excel will add second Series: Hourly Wage.
Click OK.
Keep going...
