Share via

Missing Axis Type option

Anonymous
2018-02-06T04:53:21+00:00

I need to plot some rainfall data for a large number of years.

I am plotting using the XY Scatter with straight lines and markers.

I have the date along the horizontal axis, and want to set the major and minor units to years and days (rather than 365 days and 30.4 days).

Excel help says I can do this by selecting the date axis from Axis Type, however I do not have this option, and I do not understand why?

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. Anonymous
    2018-02-06T05:50:32+00:00

    That option only appears if you are using a Line chart, not an XY Scatter, so you need to change your chart type.

    63 people found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest