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.
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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks