Y axis x 2

Is it possible to combine these 2 tables together by job abbreviation (header row) on X-axis?

And 2 Y-axes, one for MMM-YYYY (column chart), other for Length of Service (line chart)?

If so, how?!