Excel change display of date on x axis

adam McLEAN 0 Reputation points
2026-11-17T00:15:36.78+00:00

Excel for Mac using version 16.115

I have two columns one with date over 20 years shown on x axis and one with data shown on y axis.

The dates and grid lines generated by Excel for the X axis seem random and do not correspond with dates in column and or a meaning full interval.

I would like to have the dates correspond to the dats on the data from the column OR say every six months For example starting at 1/1/Year, 1/7/year and so on.

I have right clicked on x axis and gone to and gone to format axis but can't change it.

Pleases help

Microsoft 365 and Office | Excel | For home | MacOS
0 comments No comments

2 answers

Sort by: Most helpful
  1. TaoLi 121.4K Reputation points Independent Advisor
    2026-11-17T01:05:13.2833333+00:00

    Hi,

    Select the chart >> Chart Design >> Change Chart Type >> Line with Markers.

    Right-click the X-axis >> Format Axis >> Axis Options >> Date axis.

    Keep Base unit as Days, set Minimum to 1/1/2006, and Major unit to 6 Months.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments

  2. adam McLEAN 0 Reputation points
    2026-11-17T00:18:24.54+00:00

    Screenshot 2026-11-17 at 11.17.12 am

    Screenshot 2026-11-17 at 11.17.04 am

    Was this answer helpful?

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.