If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Quarterly Data in Pivot Table
Hi Everyone,
I am using Excel 2003. I just made my first pivot table last week. I have a chart and a sheet that I created from the wizard. I have grouped by years, quarters and months. On my sheet, I can see the years and months but not the data by quarter. I have noticed that I can double click on my year and it collapses down. I only have data from April thru Dec 2008, then Jan thru Dec 2009, and this year Jan thru March. I would like to know how to view the quarter data Thanks, Linda |
#2
|
|||
|
|||
Quarterly Data in Pivot Table
Hey Guys,
Nevermind. I just dropped the month out of my grouping and now have by quarter but I do have another question. My column chart shows the data by year so my quarters don't sit side by side. I want to see a column for each quarter in the same section. Hope this makes sense. Thanks, Linda "Linda RQ" wrote in message ... Hi Everyone, I am using Excel 2003. I just made my first pivot table last week. I have a chart and a sheet that I created from the wizard. I have grouped by years, quarters and months. On my sheet, I can see the years and months but not the data by quarter. I have noticed that I can double click on my year and it collapses down. I only have data from April thru Dec 2008, then Jan thru Dec 2009, and this year Jan thru March. I would like to know how to view the quarter data Thanks, Linda |
#3
|
|||
|
|||
Quarterly Data in Pivot Table
Hi Linda
Drag Year to the Column area of the PT, then your Quarters will be side by side. -- Regards Roger Govier Linda RQ wrote: Hey Guys, Nevermind. I just dropped the month out of my grouping and now have by quarter but I do have another question. My column chart shows the data by year so my quarters don't sit side by side. I want to see a column for each quarter in the same section. Hope this makes sense. Thanks, Linda "Linda RQ" wrote in message ... Hi Everyone, I am using Excel 2003. I just made my first pivot table last week. I have a chart and a sheet that I created from the wizard. I have grouped by years, quarters and months. On my sheet, I can see the years and months but not the data by quarter. I have noticed that I can double click on my year and it collapses down. I only have data from April thru Dec 2008, then Jan thru Dec 2009, and this year Jan thru March. I would like to know how to view the quarter data Thanks, Linda |
#4
|
|||
|
|||
Quarterly Data in Pivot Table
So easy!
Thanks Roger. "Roger Govier" wrote in message ... Hi Linda Drag Year to the Column area of the PT, then your Quarters will be side by side. -- Regards Roger Govier Linda RQ wrote: Hey Guys, Nevermind. I just dropped the month out of my grouping and now have by quarter but I do have another question. My column chart shows the data by year so my quarters don't sit side by side. I want to see a column for each quarter in the same section. Hope this makes sense. Thanks, Linda "Linda RQ" wrote in message ... Hi Everyone, I am using Excel 2003. I just made my first pivot table last week. I have a chart and a sheet that I created from the wizard. I have grouped by years, quarters and months. On my sheet, I can see the years and months but not the data by quarter. I have noticed that I can double click on my year and it collapses down. I only have data from April thru Dec 2008, then Jan thru Dec 2009, and this year Jan thru March. I would like to know how to view the quarter data Thanks, Linda |
Thread Tools | |
Display Modes | |
|
|