Multiple Axis & Chart Type in Single Chart

[jgangi]

I am attempting to replicate the chart as seen on page 23 of the JP Morgan Chase earnings release for the financial institution I work for.

I am struggling to make it work. I will be happy to send the Excel file if requested.

My data is layed out as follows:

Column A - Date
Column B - Total Loans
Column C - Loan Loss Reserve
Column D - Nonperforming Loans
Column E - Loan Loss Reserve / Total Loans (in percent)
Column F - Loan Loss Reserve to Nonperforing Loans (in percent)

http://files.shareholder.com/downlo...d7455838/4Q12_Earnings_Presentation_FINAL.pdf