| 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 |
| 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 | |||
Threaded Mode
