Grouping dates in PivotTable/Chart

H

Heidi

My data set includes data from approximately 3 years (daily data). I'd like
to use the group data function in PivotTables/Charts to get weekly, monthly
etc. averages.

Unfortunately, if I choose "month", it groups ALL Januarys together and
doesn't separate them out by year.

Can I get individual monthly averages with this feature? Is there a better
way to get individual weekly, monthly, quarterly and yearly average graphs
quickly and easily?

Thank you!

Heidi
 
P

Priti

Hi
You can choose Months and Years to group the pivot table so that it displays
the yearly and then monthly data respectively. You can also seperate the data
by quarters. Right click on the pivot table date field and then group it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Graphing weekly/monthly averages 4
SUM & OFFSET & PIVOT TABLE?? 0
Grouping Dates in a PivotTable 2
PivotTable/Chart - Statistics (Excel 2007) 1
Chart Object source data problem 5
Date gaps in chart after pivotTable 0
"John Smith" in source data appears as "t k" in PivotTable 2
Aggregating Data in Other Category on Pie Chart 2

Top