Plot Data by Weeks but Show Months on X Axis

[lorber123]

I have a pivot chart that needs to display the data by weeks as seen in the attached, but I want the x axis to only display months.

[Andy Pope]

In the pivot table rows field right click and use the Group option.
Start by grouping by days only and set Number to 7.
Then also group by month and year.