This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am using Microsoft 365 Excell and have come across new unwanted problem :)
The pivot table and chart keeps changing date grouping to days . I have gone to the file options and made sure that:
I make sure when grouping that the date range covers all dates for may data.
Despite the above file keeps changing my grouping. PLS HELP !
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
tanks for responding so fast. as I am not using any cloud at the moment it will take mw while to send you the link.
Could you share a test file to reproduce your issue? Then I can give suggestions on it.
For sharing file, you may upload it to OneDrive or any other cloud drive and then post the link here. *Please make sure you have removed any sensitive or private information in the sample file before uploading.