I have a chart in Excel that covers a couple of years. The X axis is the timeline. The data points on the line are one per day, therefore there are over 700 data points on the line.

I have the axis label units set to Major: 1 Months, Base: Days. This produces one label per month aligned with the major tick lines. Each date label is effectively the 1st of the month. I have rotated the labels through 270 degrees.

Problem: I want to position the labels centrally between the major tick lines, but I’ve been unable to find the right settings, if there are any.

Can anyone point me in the right direction for this please?