Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Graphics coming from a Pivot Table. PLEASE HELP!!
I need to create a graphic that reflects the credit grades variation of my
clients. So for each grade I would need two columns, old grades, and Uptdated grade, ie: "A+" column should have "old Credit Grades" and "updated credit grades", then A, B, C and D the same criteria. I don't know how to put it on my pivot table layout, I try to combine the data in different ways: column, data and row, but I never get to what I want. Please Help!! ps: I also have "loan numbers" and "loan balance" columns that I can use on the pivots if needed. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Graphics coming from a Pivot Table. PLEASE HELP!!
Can you type a couple of rows of sample data, and how you'd like that to
appear in the pivot table? HERNAN wrote: I need to create a graphic that reflects the credit grades variation of my clients. So for each grade I would need two columns, old grades, and Uptdated grade, ie: "A+" column should have "old Credit Grades" and "updated credit grades", then A, B, C and D the same criteria. I don't know how to put it on my pivot table layout, I try to combine the data in different ways: column, data and row, but I never get to what I want. Please Help!! ps: I also have "loan numbers" and "loan balance" columns that I can use on the pivots if needed. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Graphics coming from a Pivot Table. PLEASE HELP!!
Yes I would like something like this:
60 40 75 25 35 65 A+ A+ A A B B Original CS Updated CS ; Original CS Updated CS ; Original CS Updated CS Total Loans 100, so 60 Loans were A+, and now I have 40 A+, the same with A, B etc "Debra Dalgleish" wrote: Can you type a couple of rows of sample data, and how you'd like that to appear in the pivot table? HERNAN wrote: I need to create a graphic that reflects the credit grades variation of my clients. So for each grade I would need two columns, old grades, and Uptdated grade, ie: "A+" column should have "old Credit Grades" and "updated credit grades", then A, B, C and D the same criteria. I don't know how to put it on my pivot table layout, I try to combine the data in different ways: column, data and row, but I never get to what I want. Please Help!! ps: I also have "loan numbers" and "loan balance" columns that I can use on the pivots if needed. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Graphics coming from a Pivot Table. PLEASE HELP!!
In the pivot table, put Original CS in the Row area, Updated CS in the
Column area, and Count of Original CS in the Data area. The Grand Total at the right will show the original totals per grade. The Grand Total at the bottom will show the updated totals per grade. Or, instead of using a pivot table, use the COUNTIF function to summarize the data. For example, list the grades in cells G2:G6, then in cell H2, enter the following formula, to summarize the original CS: Original CS A+ =COUNTIF(B:B,$G2) A B C D HERNAN wrote: Yes I would like something like this: 60 40 75 25 35 65 A+ A+ A A B B Original CS Updated CS ; Original CS Updated CS ; Original CS Updated CS Total Loans 100, so 60 Loans were A+, and now I have 40 A+, the same with A, B etc "Debra Dalgleish" wrote: Can you type a couple of rows of sample data, and how you'd like that to appear in the pivot table? HERNAN wrote: I need to create a graphic that reflects the credit grades variation of my clients. So for each grade I would need two columns, old grades, and Uptdated grade, ie: "A+" column should have "old Credit Grades" and "updated credit grades", then A, B, C and D the same criteria. I don't know how to put it on my pivot table layout, I try to combine the data in different ways: column, data and row, but I never get to what I want. Please Help!! ps: I also have "loan numbers" and "loan balance" columns that I can use on the pivots if needed. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Graphics coming from a Pivot Table. PLEASE HELP!!
Thank you Debra;
I tried what you told me, but is not what I want. I end up having rows with credit grades AND columns with credit grades and I need two columns one with the old data and the otherone with the updated data. I need to have 2 columns next to each other that represent the same thing; but one with the original data and the other one with the update data, I will give you an easier example for me: Apples: one column will show how many I sold in 2006 the other one how many in 2007, then another one for oranges, potatoes etc with the same criteria I need to show how my clients credit score improve from last year up today ie: A+ Credit, I had 30 loans, and now I have 20. I will try the "countif" formula you told me, maybe is easier that way. "Debra Dalgleish" wrote: In the pivot table, put Original CS in the Row area, Updated CS in the Column area, and Count of Original CS in the Data area. The Grand Total at the right will show the original totals per grade. The Grand Total at the bottom will show the updated totals per grade. Or, instead of using a pivot table, use the COUNTIF function to summarize the data. For example, list the grades in cells G2:G6, then in cell H2, enter the following formula, to summarize the original CS: Original CS A+ =COUNTIF(B:B,$G2) A B C D HERNAN wrote: Yes I would like something like this: 60 40 75 25 35 65 A+ A+ A A B B Original CS Updated CS ; Original CS Updated CS ; Original CS Updated CS Total Loans 100, so 60 Loans were A+, and now I have 40 A+, the same with A, B etc "Debra Dalgleish" wrote: Can you type a couple of rows of sample data, and how you'd like that to appear in the pivot table? HERNAN wrote: I need to create a graphic that reflects the credit grades variation of my clients. So for each grade I would need two columns, old grades, and Uptdated grade, ie: "A+" column should have "old Credit Grades" and "updated credit grades", then A, B, C and D the same criteria. I don't know how to put it on my pivot table layout, I try to combine the data in different ways: column, data and row, but I never get to what I want. Please Help!! ps: I also have "loan numbers" and "loan balance" columns that I can use on the pivots if needed. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Graphics coming from a Pivot Table. PLEASE HELP!!
You didn't provide any sample data, as I asked earlier, but I assume
it's something like this: Customer OriginalCS UpdatedCS Cust01 A+ A If that's how your data is set up, a CountIF formula would be easiest. To get the pivot table arrangement that you want, the data would have to be arranged like this: Customer Type CS Cust01 Original CS A+ Cust01 Updated CS A+ Then, make a pivot table with Type and CS in the Column area, and Count of Customer in the data area. HERNAN wrote: Thank you Debra; I tried what you told me, but is not what I want. I end up having rows with credit grades AND columns with credit grades and I need two columns one with the old data and the otherone with the updated data. I need to have 2 columns next to each other that represent the same thing; but one with the original data and the other one with the update data, I will give you an easier example for me: Apples: one column will show how many I sold in 2006 the other one how many in 2007, then another one for oranges, potatoes etc with the same criteria I need to show how my clients credit score improve from last year up today ie: A+ Credit, I had 30 loans, and now I have 20. I will try the "countif" formula you told me, maybe is easier that way. "Debra Dalgleish" wrote: In the pivot table, put Original CS in the Row area, Updated CS in the Column area, and Count of Original CS in the Data area. The Grand Total at the right will show the original totals per grade. The Grand Total at the bottom will show the updated totals per grade. Or, instead of using a pivot table, use the COUNTIF function to summarize the data. For example, list the grades in cells G2:G6, then in cell H2, enter the following formula, to summarize the original CS: Original CS A+ =COUNTIF(B:B,$G2) A B C D HERNAN wrote: Yes I would like something like this: 60 40 75 25 35 65 A+ A+ A A B B Original CS Updated CS ; Original CS Updated CS ; Original CS Updated CS Total Loans 100, so 60 Loans were A+, and now I have 40 A+, the same with A, B etc "Debra Dalgleish" wrote: Can you type a couple of rows of sample data, and how you'd like that to appear in the pivot table? HERNAN wrote: I need to create a graphic that reflects the credit grades variation of my clients. So for each grade I would need two columns, old grades, and Uptdated grade, ie: "A+" column should have "old Credit Grades" and "updated credit grades", then A, B, C and D the same criteria. I don't know how to put it on my pivot table layout, I try to combine the data in different ways: column, data and row, but I never get to what I want. Please Help!! ps: I also have "loan numbers" and "loan balance" columns that I can use on the pivots if needed. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Graphics coming from a Pivot Table. PLEASE HELP!!
thank you
"Debra Dalgleish" wrote: You didn't provide any sample data, as I asked earlier, but I assume it's something like this: Customer OriginalCS UpdatedCS Cust01 A+ A If that's how your data is set up, a CountIF formula would be easiest. To get the pivot table arrangement that you want, the data would have to be arranged like this: Customer Type CS Cust01 Original CS A+ Cust01 Updated CS A+ Then, make a pivot table with Type and CS in the Column area, and Count of Customer in the data area. HERNAN wrote: Thank you Debra; I tried what you told me, but is not what I want. I end up having rows with credit grades AND columns with credit grades and I need two columns one with the old data and the otherone with the updated data. I need to have 2 columns next to each other that represent the same thing; but one with the original data and the other one with the update data, I will give you an easier example for me: Apples: one column will show how many I sold in 2006 the other one how many in 2007, then another one for oranges, potatoes etc with the same criteria I need to show how my clients credit score improve from last year up today ie: A+ Credit, I had 30 loans, and now I have 20. I will try the "countif" formula you told me, maybe is easier that way. "Debra Dalgleish" wrote: In the pivot table, put Original CS in the Row area, Updated CS in the Column area, and Count of Original CS in the Data area. The Grand Total at the right will show the original totals per grade. The Grand Total at the bottom will show the updated totals per grade. Or, instead of using a pivot table, use the COUNTIF function to summarize the data. For example, list the grades in cells G2:G6, then in cell H2, enter the following formula, to summarize the original CS: Original CS A+ =COUNTIF(B:B,$G2) A B C D HERNAN wrote: Yes I would like something like this: 60 40 75 25 35 65 A+ A+ A A B B Original CS Updated CS ; Original CS Updated CS ; Original CS Updated CS Total Loans 100, so 60 Loans were A+, and now I have 40 A+, the same with A, B etc "Debra Dalgleish" wrote: Can you type a couple of rows of sample data, and how you'd like that to appear in the pivot table? HERNAN wrote: I need to create a graphic that reflects the credit grades variation of my clients. So for each grade I would need two columns, old grades, and Uptdated grade, ie: "A+" column should have "old Credit Grades" and "updated credit grades", then A, B, C and D the same criteria. I don't know how to put it on my pivot table layout, I try to combine the data in different ways: column, data and row, but I never get to what I want. Please Help!! ps: I also have "loan numbers" and "loan balance" columns that I can use on the pivots if needed. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
can anyone help with times not coming across correctly in pivot t. | Excel Worksheet Functions | |||
can anyone help with times not coming across correctly in pivot t. | Excel Worksheet Functions | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel |