Pivot tables Charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a chart that shows how my client's credit score changed from 2006 to
2007:
I would like to have it in groups by Credit Grades like this:

First column: "A Credits" in 2006: 20 Loans;
.... and A credits in 2007: 30 loans.

Second column: "B Credits" in 2006 10 Loans;
....and A credits in 2007: 40 Loans.


it Should look like this:

20 30 10 40
A A B B
2006 2007 2006 2007


I must be done in a pivot table.
Thank you.
 
Back
Top