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.

Pivot tables Charts
 

Helpful advice here...
http://www.catb.org/~esr/faqs/smart-questions.html
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"HERNAN"

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.

Pivot tables Charts
 

Did work, thank you

"Jim Cone" wrote:


Helpful advice here...
http://www.catb.org/~esr/faqs/smart-questions.html
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"HERNAN"

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.