Share via

Dates revert to first of month on Excel Chart

Anonymous
2023-08-21T14:44:33+00:00

So I am plotting a couple different charts (Line chart, stacked chart) showing data running from 6/30/22 until 6/30/23. When I set up the charts, the dates along the axis revert to the 1st of the month, so 6/1/23 instead of 6/30/23.

I googled a solution and most said under format axis, select Text Axis under Axis Type. When I do that, it just screws up the chart field. It compresses the line and stacked bar charts and shows only two dates.

Any solution?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.4K Reputation points MVP Volunteer Moderator
    2023-08-21T14:56:26+00:00

    Expand 'Tick Marks' in the Format Axis pane.

    Make sure that 'Interval between marks' is set to 1.

    You may also want to set the maximum value of the x-axis to automatic.

    1 person found this answer helpful.
    0 comments