I am setting up a pivotchart that summarises people starting with a service from a particular area. The data being used is:
- unique person ID
- area
- date started
I want to group the days into 7 day periods. However, on the X-Axis each entry shows as Date From and Date To for each 7 day period eg 15/02/2024 - 21/02/2024.
Is there a way for the X-axis labels to just show the Date From date for each 7 day period. This would improve the readability of the graph immensely.
| Weeks | Number of Referrals |
|---|---|
| 24/03/2022 - 30/03/2022 | 1 |
| 11/01/2024 - 17/01/2024 | 27 |
| 18/01/2024 - 24/01/2024 | 37 |
| 25/01/2024 - 31/01/2024 | 35 |
| 01/02/2024 - 07/02/2024 | 22 |
| 08/02/2024 - 14/02/2024 | 28 |
| 15/02/2024 - 21/02/2024 | 33 |
| 22/02/2024 - 26/02/2024 | 22 |
| Grand Total | 1946 |
Here's a screenshot of the pivottable:
Thank you