Multiple Chart Types in Single Chart

[jgangi]

I am attempting to replicate the chart that is found on page 23 of this PDF for the financial institution I work for.


I have tried a variety of different things, but cannot find a solution.


http://files.shareholder.com/downloads/ONE/2371000299x0x628658/39950186-903d-4457-9e62-1aefd7455838/4Q12_Earnings_Presentation_FINAL.pdf


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 (Percent)

Column F - Loan Loss Reserve / Nonperforming Loans (Percent)


My Excel file has the Chase data in it and I will be happy to provide a copy upon request.

 

[Hui]

It is a stacked Column Chart left axis

and two series as a Line chart right axis

The Columns have custom Chart labels


Have a look at: https://www.dropbox.com/s/t9hef6f2ybhhwt7/jgangi.xlsx

Except I laid the data out in Rows, Whoops