google-sheetshistogramnumber-formatting

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


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.

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

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

Thanks for your help!


Solution

  • 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.

    screenshot of chart settings