Display Or Change Dates On Category Axis. Your x axis should now display your dates in the correct order. SubDayTextFormatting used when VisibleRange shows less than a day You can find out more as well as how to dynamically change text formatting at the following links.
SubDayTextFormatting used when VisibleRange shows less than a day You can find out more as well as how to dynamically change text formatting at the following links. Then you should have the options to set base unit as month and so on. Unlike the treatment of text or numbers as nonnumeric category labels the dates are treated as numerical dates with the spacing between points proportional to the number of days between points.
Select the data file and click Open.
For the axis that you want to change make sure that the axis labels show. These essays are fairly old still referencing Excel 2003 so some of the dialogs are different but the basic principles between horizontal value axis date axis or category axis. In the HorizontalAxis Properties dialog box select Number. In order to get those options you need to change your chart type to line and make sure that Excel designates the horizontal axis as a date axis.