A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Excel change display of date on x axis
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
2 answers
Sort by: Oldest
-
TaoLi 121.6K Reputation points Independent Advisor2026-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.