Share via

How do I display dates on the Horizontal axis of a chart

Anonymous
2018-08-20T15:22:11+00:00

I am following this steps to display date on the horizontal axis of a chart:

  1. Click the chart, and then click the Chart Design tab.
  2. Click Add Chart Element, click Axes, and then click More Axis Options. The Format Axis pane appears.
  3. For the axis that you want to change, make sure that the axis labels show.
  4. Under Axis Type, select Date axis.
  5. Under Units, in the Base drop-down list box, select Days, Months, or Years.

When I get to step 4, I can not find "Date axis".

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

Answer accepted by question author

  1. Jim G 134K Reputation points MVP Volunteer Moderator
    2018-08-20T17:00:46+00:00

    Hi Jim,

    Right click on the horizontal axis and choose Format Axis

    In the Format Axis pane, click the disclosure triangle for Number, and then change the Category to Date and choose a Type.

    9 people found this answer helpful.
    0 comments

Answer accepted by question author

  1. Vijay A. Verma 104.8K Reputation points Volunteer Moderator
    2018-08-20T17:15:25+00:00

    As I had pointed in my first reply - The kind of graph you are showing seems to be made on the basis of one column of data, that is why it is showing 1, 2, 3..

    Your chart is made on only one column i.e. B. You needed to make chart on columns A and B. Select A1:B10 and then make the chart.

    2 people found this answer helpful.
    0 comments

5 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2018-08-20T15:30:19+00:00

    If your chart is an XY Scatter chart, there is no 'Axis type' option. This option is available for Line charts (among others). And it only works if the x-axis values are dates. Month ending 1, 2, 3, … aren't dates.

    3 people found this answer helpful.
    0 comments
  2. Anonymous
    2018-08-20T16:03:32+00:00

    Attached is a screenshot of the whole spread sheet.  Column B is the vertical axis Column A is the horizontal axis and is in date format.

    0 comments
  3. Vijay A. Verma 104.8K Reputation points Volunteer Moderator
    2018-08-20T15:30:59+00:00

    Date axis will be displayed if the values are recognized as dates in your table in first column. Can you post the screenshot of your data without any confidential / sensitive data?

    The kind of graph you are showing seems to be made on the basis of one column of data, that is why it is showing 1, 2, 3..

    0 comments