A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Quarterly Data in Pivot Table



 
 
Thread Tools Display Modes
  #1  
Old April 20th, 2010, 06:06 PM posted to microsoft.public.excel.newusers
Linda RQ[_2_]
external usenet poster
 
Posts: 76
Default 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  
Old April 20th, 2010, 06:21 PM posted to microsoft.public.excel.newusers
Linda RQ[_2_]
external usenet poster
 
Posts: 76
Default 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  
Old April 21st, 2010, 11:43 AM posted to microsoft.public.excel.newusers
Roger Govier[_8_]
external usenet poster
 
Posts: 338
Default 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  
Old April 23rd, 2010, 03:43 PM posted to microsoft.public.excel.newusers
Linda RQ[_2_]
external usenet poster
 
Posts: 76
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:12 AM.


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