'Excel chart x-axis not showing correct beginning of month

In Excel, I have data for the last year on Nasdaq100 adjusted close.

enter image description here

The issue here is that, if I choose the mmm-yy format for the x-axis, the month ticks will be on the 17th of each month, instead of the beginning.

What should I do to make them refer to the beginning of each month?

Thank you.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source