PLEASE HELP!! SIMPLE PIVOT CHART

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.


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
 
P

Peo Sjoblom

Please refrain from multiposting, continue in the same thread.
I am not doing this because I am a net nanny but because you will have less
chance to get an answer since many regulars routinely flag multipost
messages
as ignore since it is a waste or resources. Since I saw that you were
getting answers from the
person who is IMHO the best authority on pivot tables you probably blew this
one

Given that you "must" use a pivot it makes me think that this is school
work?


--


Regards,


Peo Sjoblom
 
G

Guest

Excuse me ... WHO are you???
If you are not going to anwer my question then why don't you bother someone
else, thank you nanny
 
G

Guest

...."the best authority in pivot tables"!!lol who talks like that??? are you
for real man?
just an advice to you,... get a job or a girlfriend, (or maybe boyfriend in
your case)
I found the answer so I'm not going to multipost and waste RESOURCES lol!!!
 
D

David Biddulph

If you had taken the trouble to read the group, you would have seen that Peo
is a regular, helpful, and well-respected contributor to the group. If you,
as a new poster to the group, take that sort of attitude to a contributor
who is giving you helpful advice, you are likely to find yourself ignored by
the vast majority of contributors.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot tables Charts 2
matching a column of numbers to another in another spreadsheet 1
Calculate Difference between 2 columns in Pivot table 1
Pivot Chart - Excel 2013 - Rotating Second and Third Lines of text onthe Horizontal Axis 0
conditional formatting in pivot tables based on another column 4
I Need a forumula or VBA code 1
Animated text over a video background??? 1
Find Every Occurance matching one Row and One Column 2

Top