Excel Charting

[ubns]

Please have a look at this chart - attached file.

I want to show affordable years by line and rest all in bar form. but all with the use of one chart.



can someone suggest how to do that?

also please look at left axis, any suggestions to make it more scaled to all the value at present obviosuly it is skewed to the numbers in affordable column -- is it something to do with major or minor unit of the axis.

thanks in advance.