Forum Discussion
Rocky3348
Dec 07, 2022Copper Contributor
Problem with Date axis on Excel 365
I am trying to plot some values (Y axis) with dates on the X axis.
When I choose the dates as the horizontal axis the correct dates are not shown correctly.
The dates are displayed as the last day of each month, so as my dates are in November and December all the plot is up one end of the graph.
I could not see anything in the Format Axis to change this.
It looks like there must be at least one date in January. Perhaps a typo?