Problem with Date axis on Excel 365

Copper Contributor

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.Excel Chart1.jpg

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.

Excel Chart2.jpg

I could not see anything in the Format Axis to change this.

1 Reply

@Rocky3348 

It looks like there must be at least one date in January. Perhaps a typo?