View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
HERNAN HERNAN is offline
external usenet poster
 
Posts: 103
Default Pivot tables Charts

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.