Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
PLEASE HELP!! SIMPLE PIVOT CHART
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 "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: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
PLEASE HELP!! SIMPLE PIVOT CHART
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 "Peo Sjoblom" wrote: 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 "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: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
PLEASE HELP!! SIMPLE PIVOT CHART
...."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!!! "Peo Sjoblom" wrote: 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 "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: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
PLEASE HELP!! SIMPLE PIVOT CHART
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. -- David Biddulph "HERNAN" wrote in message ... 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 "Peo Sjoblom" wrote: 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 "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: 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
PLEASE HELP!! SIMPLE PIVOT CHART
bla bla bla bla bla....
hey Peo I found you a boyfriend here... "David Biddulph" wrote: 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. -- David Biddulph "HERNAN" wrote in message ... 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 "Peo Sjoblom" wrote: 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 "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: 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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
PLEASE HELP!! SIMPLE PIVOT CHART
thank you
"HERNAN" wrote: 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 "Peo Sjoblom" wrote: 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 "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: 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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
PLEASE HELP!! SIMPLE PIVOT CHART
What are you,14 years old?
-- Regards, Peo Sjoblom "HERNAN" wrote in message ... ..."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!!! |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
PLEASE HELP!! SIMPLE PIVOT CHART
Peo... again,.. GET A REAL JOB MANNNNN!!
"Peo Sjoblom" wrote: What are you,14 years old? -- Regards, Peo Sjoblom "HERNAN" wrote in message ... ..."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!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple Calculation within pivot table | Excel Worksheet Functions | |||
A simple chart.. | Charts and Charting in Excel | |||
simple chart question | Excel Worksheet Functions | |||
Simple chart | Charts and Charting in Excel | |||
Pivot Tables - "simple" question | Excel Discussion (Misc queries) |