Share via

Why are the dates not displayed properly

Anonymous
2022-10-20T10:26:15+00:00

I have a table (Date Ruby) but when I look at it as a graph the dates are not displayed as shown.

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

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.4K Reputation points MVP Volunteer Moderator
    2022-10-20T10:42:04+00:00

    Option 1:

    Click in the chart.

    Double-click any of the x-axis labels.

    In the Format Axis task pane, under Axis Options, select 'Text Axis'.

    Option 2:

    Change the chart type from Line Chart to XY Scatter Chart.

    0 comments
  2. Anonymous
    2022-10-20T13:00:51+00:00

    Thanks HansV, Sorted. It seem that depending on the type of chart (Bar/Line) you get different results.

    0 comments