Advanced Combo chart (Funnel)

I was trying to create a Advanced funnel custom chart in Excel using combo option. I prepared the same using inverted axis, secondary axis, area chart, bar chart and line chart, . Only to find out that I can't rotate the chart by 90 degree (By rotating I get the final appearance as required. Enclosed)

Then I tried to use bar chart and line chart and added helping column to get the similar outcome but I am having hard time making the line chart understand to take numerical data on X axis and category on Y axis.  Hereby enclosing the last step from where I want to have the the said Line chart)

Date is below if required: