| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Grouping dates in PivotTable/Chart
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Grouping dates in PivotTable/Chart
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. -- Priti "Heidi" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PivotTables - Group Dates, excluding dates | Excel Discussion (Misc queries) | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
| Pivot table grouping of dates in row fields will not work. Why? | Excel Worksheet Functions | |||
| Grouping Dates in Pivot tables | Excel Discussion (Misc queries) | |||
| grouping dates by week/month/etc. on cat. axis | Charts and Charting in Excel | |||
Linear Mode
