Overlay data by week

I have a set of data that has been gathered over the past year, and I want to see what the trend looks like across each week. I'd like each week to be laid on top of the other weeks so I can get a general trend.
I've tried using a pivot table, but I can only get that to give me the days of the week, then it adds all the data together for each weekday, rather than overlaying all the data points. If I do it in a normal chart, I can only get the data (I'm testing with one month at this stage) spread out across all the dates of the month, not overlaid by week.

Insert an Index column and create a PivotTable and a corresponding chart.

Overlay data by week.png

Thanks, I've replied below (sorry, new to this forum and how to do things). Any further suggestions would be much appreciated. Cheers

Basically, I'd like to group the dates by week, but excel doesn't give me that option - only hours, days, months etc.

some time due to various excel file are corrupted...

It would be helpful if you can show how your chart will look like, and what's the values for X and Y-axis.

Hi,

This is what I'm after, but without having to break the data up into separate weeks. Currently the data is sitting in separate spreadsheets for each month.