I am completely bewildered that Excel does not include this as an option when dealing with dates for charts. All I want to do is have a chart that shows data by month and then a simple line that makes it easier to see changes between years. I have searched for over 6 hours and nothing out there seems to work. I can change the Major units to Years and the Minor to Months but this only shows labels of dates yearly. I want the labels to show dates monthly with a gridline to show changes in years. Why is this so damn hard to do? It seems like an obvious thing that people would want to see!