Date grouping on pivot chart axis

Hello everyone

I have been using this great forum for troubleshooting, but now decided to register as I couldn't find solution to my problem.

I have created a pivot chart (line chart) with inventory values on vertical axis and dates on horizontal axis. I.e. the data points are inventory registrations on certain timestamps, I need to have the data open on minute level. As there are many events, the date axis is quite messy, because it shows the registrations by minute. What Im looking for:how can I group the horizontal axis to show only months, but keep the data points on minute level as they are and need to be?

In screen cap shown with yellow what I want to keep on the axis.

Capture.PNG

Cheers for help!

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.