Custom Graphing: 3 Column Charts for Single CU/Peer Group?

There are 3 different column charts under Single CU/Peer Group. Let's take a look at the difference between them:

1. Single Cycle: This one shows you a different column for each account in a single cycle. Not sure how often you'd use...but here's an example to show the total $ outstanding for various components of the loan portfolio.

2. Historical: This one is more useful. It shows you multiple accounts going back over time for a single CU or PG. This is the same as the line chart next to it. I usually use columns when measuring balances and the line for ratios. Not sure why...Here are 2 examples:
3. Stacked Column (Historical): My favorite. Use this to look at composition changes historically. Here is an example showing the changing composition of the average credit union share portfolio over time. (I'm using the "All US" peer group...thus the 'average' composition for the entire industry). Note the shift toward share certificates starting in 2006...

Bonus! I just learned something myself. You can use the Type menu above this chart to turn it into a stacked area chart. This yields the same result as having selected the Area Chart. Yay. Once less blog post.

Note: the Account Selection screen is the same for all of them...just realize when you select type 2, each account code you is a different column. For type 3, each account code is stacked on top of the others, rather than next to them.

And with that bonus find, I'm treating myself to a 3-day weekend (I'm actually on a 7-day vacation as you read this but I felt compelled to prepare tips for my 3 loyal Jedi-in-training while I am overseas.) My next post will be on Tuesday, July 21 and cover Historical Tables.