View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
HERNAN HERNAN is offline
external usenet poster
 
Posts: 103
Default PLEASE HELP!! SIMPLE PIVOT CHART


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.


Should look like this:

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


This chart should come from a pivot table, so what should I have on my pivot
in order to accomplish that???
Thank you