Why is this line chart not working?

[sokatenaj]

Hi Folks,

All I want to do is show the headcount by month as a line chart and then the revenue by month on the same chart as a line to see the trend of headcount versus revenue by month. Why the heck isn't it working? 

My data is as follows: 

Date	People	Revenue
Jan-16	601	429,013
Feb-16	606	435,222
Mar-16	609	433,774
Apr-16	607	441,002
May-16	619	445,799
Jun-16	633	447,529
Jul-16	638	449,442
Aug-16	643	451,815
Sep-16	637	455,573
Oct-16	649	457,381
Nov-16	658	448,980
Dec-16	663	434,386
Jan-17	668	434,174
Feb-17	665	408,879
Mar-17	655	399,544
Apr-17	625	397,531
May-17	616	397,587
Jun-17	598	392,385
Jul-17	595	380,811
Aug-17	592
Sep-17	589
Oct-17	584
Nov-17	580
Dec-17	575

All I get are flat lines. I don't want bar charts/line combos. I just want two lines with two Y axes.   Left Y axis to be Headcount, Right Y to be Revenue so that I can show correlation. Why is this so complicated? Am I missing a step?

[KHorseman]

There is no line chart visual with 2 separate y-axes. There is a combo column and line chart that has independent y-axes.

[sokatenaj]

Well how do I compare headcount to revenue then with 2 lines? I can't do it because headcount is all the way down at the bottom and revenue is all the way up at the top? 

[KHorseman · Accepted solution]

Aside from making a custom visual to suit your particular needs, I suggest using the combo column and line chart.

[sokatenaj]

Thanks @KHorseman. Unfortunately, it won't give me the visualization I need. I'll just do it in Excel and paste as an image 🙂 

[robofski]

You could perhaps create a measure of your revenue figure  divided by 1000 and label it as Revenue ('000) and plot that, that would give you numbers that are much closer together on the same axis which may work.

[sokatenaj]

*blinks* Hmm...That's not a bad idea...I'll try it out! Thanks!