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