Google Sheets: Number Format option of horizontal axis labels in a histogram

Question

I would like to change the number format of the horizontal axis labels of a histogram. Some tutorials mention that this should work, e.g.

• New chart text and number formatting options in Sheets
• How To☝️ Change Axis Scales In A Google Sheets Chart

However, the option to change the number format seems to be gone, see the following screenshot:

Is it possible that Google removed that feature? And/or can this be done differently?

Thanks for your help!

Answer 1

I had this same issue. I originally had my data set only as the Series, and nothing was set as the X-axis.

Once I set the same data range as both the Series and the X-axis, that enabled the number format option under Chart Editor -> Customize -> Horizontal axis.

Answer 2

I believe this question is more suitable for Superuser, but:

In "Chart editor" select "Setup", find option "Treat labels as text" and untick it:

Now you can choose format for horizontal axis: