CHART - Mixed BAR and 2 LINES

[Beth Dye]

I have a char

X axis = Team Name
First Y axis = No of Contract Actions
Second Y axis = No 0f Personne

First Y axis = BAR display of Number of Contract Actions per tea
Second Y Axis = LINE display of Staffing Model Personnel Require
I want to have another LINE display of Staffing Onboar

Both of the staffing (Model and Onboard) are LINE displays of No of Personne
The Contract Actions is a COLUMN BAR display of No of actions done by the specific tea

I can get one BAR and one LINE.

I can't seem to figure out how to get the second LINE

I can't copy and paste the first and just change the data range
I can't find a chart type that shows/allows what I am trying to d
I have seen this done on other charts
Any guides anywhere to help with this type of chart

 

[Lance]

If you select the data series on the graph (left click
the series) and right click for the menu to change the
chart type, you can change the chart type for any
individual series.

Lance

-----Original Message-----
I have a chart

X axis = Team Names
First Y axis = No of Contract Actions
Second Y axis = No 0f Personnel

First Y axis = BAR display of Number of Contract Actions per team
Second Y Axis = LINE display of Staffing Model Personnel Required
I want to have another LINE display of Staffing Onboard

Both of the staffing (Model and Onboard) are LINE displays of No of Personnel
The Contract Actions is a COLUMN BAR display of No of

actions done by the specific team