| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set a pivot table to group quarterly reports by F/Y? | Excel Discussion (Misc queries) | |||
| Quarterly Statements in Pivot Tables | Excel Discussion (Misc queries) | |||
| Lookup data in a variable table & retrieve data from a pivot table | Excel Worksheet Functions | |||
| Pivot Table - Quarterly report | Excel Discussion (Misc queries) | |||
| Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
![Linda RQ[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
