MS Excel Scatter Chart Missing Axis Type Option

Question

I don't see the option to select "date" as axis type in the attached scatter chart.  Can not figure out why it's not giving me the option to do so. 

Answer 1

See here:-

https://support.office.com/en-us/article/Present-your-data-in-a-scatter-chart-or-a-line-chart-4570A80F-599A-4D6B-A155-104A9018B86E#bmchartdifferences

 - where it states:-

a scatter chart never displays categories on the horizontal axis

 -and:-

A scatter chart always has two value axes to show one set of numerical data along a horizontal (value) axis and another set of numerical values along a vertical (value) axis.

Answer 2

this does not address my problem at all

Answer 3

this does not address my problem at all

See if the posting that I've just made here then:-

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10-mso_2016/excel-2016-format-axis-axis-options-does-not-give/a1fd7dc3-8677-4b36-86f3-1534701a1f95?messageId=61ff8e33-3a7b-4054-9833-cd7644391b59

 - helps you out.

Answer 4

Ryan -

I am working on a brand new MacBrook Pro with Excel for Mac (version 15.39) installed. I am having the same problem as Kimbrulay where formatting the horizontal axis does not allow me to pick the type (text or date).

Thanks.

Answer 5

I do not see where in that link it addresses this issue. I am having the exact same issue as kimbrulay.