Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 103
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,268
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 103
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 103
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 103
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 103
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,268
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 103
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Simple Calculation within pivot table toryc Excel Worksheet Functions 0 October 19th 06 10:51 PM
A simple chart.. Freddie Mac Charts and Charting in Excel 1 July 2nd 06 02:26 AM
simple chart question Shooter Excel Worksheet Functions 1 July 26th 05 06:48 PM
Simple chart TomC Charts and Charting in Excel 3 May 5th 05 01:31 AM
Pivot Tables - "simple" question Eoin Bairead Excel Discussion (Misc queries) 1 February 28th 05 07:07 PM


All times are GMT +1. The time now is 02:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"