Pivot tables Charts

[HERNAN]

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.

 

[Jim Cone]

Helpful advice here...

--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"HERNAN"
<[email protected]>
wrote in message
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:
-snip
I must be done in a pivot table.
Thank you.

 

[HERNAN]

Did work, thank you