Share via

Missing Axis Type option

Anonymous
2019-04-29T13:00:00+00:00

Hi,

I have an issue in Excel 2016, when I try to select the axis type date option for the horizontal axis (dates) it is missing. The funny thing is if I select the vertical axis (text) the option is there. Can someone help? Btw I have tried with all graphs.

Thanks in advance!

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

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-04-30T09:11:14+00:00

    Dear Vijay,

    Basically what I need is to have on the horizontal axis the dates divided by quarters not like the automatic arrangement done by excel.

    Example:

    01-01-2019 (Q1), 01-04-2019 (Q2), 01-07-2019(Q3), 01-10-2019(Q4)

    Regards,

    Was this answer helpful?

    0 comments
  2. Vijay A. Verma 104.9K Reputation points Volunteer Moderator
    2019-04-29T13:58:18+00:00

    Let me know full requirement so that I can suggest work-around or right solution.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2019-04-29T13:55:13+00:00

    Hi Vijay,

    So there is nothing I can do? I want to edit the axis with the dates for example to have it divided by months. 

    Thanks!

    Was this answer helpful?

    0 comments
  4. Vijay A. Verma 104.9K Reputation points Volunteer Moderator
    2019-04-29T13:17:21+00:00

    Hi darksantacruz

    Greetings! I am Vijay, an Independent Advisor. I am here to work with you on this problem.

    The behavior is allright. The right click options for x axis and y axis are always different. This is not about your data or chart.

    Was this answer helpful?

    0 comments