If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Arranging information so a chart makes sense
I have entered the information in what seems to be a logical way to me. But
I'm not able to get a chart that makes much sense, or that relays the information in a useful way. Maybe I need to sort it out differently. I have it entered: quarterly dates (descending order) down the 1st column, and my 1st row title/headers a Risk Rating #1, Risk Rating #2 Risk Rating #3 Risk Rating #4, Risk Rating #5, Risk rating #6, Risk Rating #7, Total number of loans, total original balance, total query balance. Then under each row header, lined up horizontally with the quarterly dates, I have 3 sub columns as follows: number of loans, $ original loan balance, $ current loan balance All I am trying to do is chart this information so I can see what's happening with the loan portfolio. I think the line graph should show the following: Volatility, and growth of the ORIGINAL loan balance on a quarterly basis. Volatility, and growth of the CURRENT loan balance on a quarterly basis. Migration of portfolio risk rating. Is the loan portfolio growing or shrinking? Thanks for any help. -- Scott S. |
Thread Tools | |
Display Modes | |
|
|