ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   PLEASE HELP!! SIMPLE PIVOT CHART (https://www.excelbanter.com/excel-discussion-misc-queries/161283-please-help-simple-pivot-chart.html)

HERNAN

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


Peo Sjoblom

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




HERNAN

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





HERNAN

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





David Biddulph[_2_]

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




HERNAN

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





HERNAN

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





Peo Sjoblom

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!!!




HERNAN

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!!!






All times are GMT +1. The time now is 02:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com