Select Range A1:D6
Insert, Chart, Column, Clustered Column
Use Up/Down arrows until the Primary Data is selected
Ctrl+1
Secondary Axis
Use Up/Down arrows until the Secondary Data is selected
Ctrl+1
Secondary Axis
Right Click on the Primary and Secondary Columns in Turn
Change Series Chart Type
Select Line for each
Select Each line in turn
Right Click
Format Data Series
Line Color
Set as required