Pivot table grouping

[SER01]

I have a sheet with some data in it that. Each row has a date and some values for that particular date. I wanted to create a chart that would plot a summary of those values. I wanted a daily weekly and monthly chart. Someone on this forum suggested that i use a pivot table. While it seems to do some of what i am after here is the problems i have.

1. There is no way to have a weekly summary just daily and monthly. Is there any way to group the data weekly?

2. I need to plot the daily, weekly and monthly data on a chart and be able to view all 3 charts simultaneously. That however seems to be impossible to achieve with a pivot table. I tried creating multiple tables but the grouping seems to apply to all of them. So if i have daily grouping on one the other one will have it too, hence i can only have one chart at any one time. Am i missing something here? What workarounds are there?

Thanks!

[arthurbr]

1. There is no way to have a weekly summary just daily and monthly. Is there any way to group the data weekly?

yes, group by 7 days

[SER01]

yes, group by 7 days

Thank you, i totally missed that.

[arthurbr]

2. I need to plot the daily, weekly and monthly data on a chart and be able to view all 3 charts simultaneously. That however seems to be impossible to achieve with a pivot table. I tried creating multiple tables but the grouping seems to apply to all of them. So if i have daily grouping on one the other one will have it too, hence i can only have one chart at any one time. Am i missing something here? What workarounds are there?

If I remember correctly when you have mad a first PT and start making a second, XL asks if you want to base the second PT on the first to save memory.
If you answer "no" the second will be independent and you can group another way.
HTH