May 22, 2024

Set Number Format of Histogram Axes

I have a histogram with data in the form of durations (tracking hours of sleep). When I add this data to the chart as a series, the chart defaults to formatting the vertical axis - the frequency data as dates/durations - and formatting the x axis - the duration data - as numbers.

Obviously I'd like this to be the other way around; the "hours slept" axis should be formatted as durations, and the frequency axis should be integers. When I examine the chart's horizontal and vertical axis settings, however, they are missing several options, including an option to set the number format of the data.

A previous thread from 2021 shows this option clearly available for histograms. I'm unsure why it's not available here. How can I correct the number formats of this chart?

Here is a link to a version of this sheet with just the sleep data.

Thank you folks for any help you can provide.

Edit: Images were removed from this post for some reason. I've re-added them.

Details

Sheets,Microsoft Windows,Personal use

Locked

Informational notification.

This question is locked and replying has been disabled.

Community content may not be verified or up-to-date. Learn more.

Last edited May 22, 2024

All Replies

Mr Shane

Diamond Product Expert

May 22, 2024

Hi Ethan Cuka,

Welcome to the Google Docs Editors help community.

From this Google announcement:

Google Workspace Updates: New chart text and number formatting options in Sheets

Set advanced number formatting options on both your data labels and axis labels, including the option to conditionally format by color.

Then, from this documentation:

Edit your chart's axes - Computer - Google Docs Editors Help

You can format the labels, set min or max values, and change the scale.
On your computer, open a spreadsheet in Google Sheets.
Double-click the chart you want to change.
At the right, click Customize.
Click Vertical axis.
Make the changes you want.

Tip: To hide the vertical axis line, uncheck the box next to "Show axis line".

The announcement is a few years old, and the documentation is incorrect so it is difficult to know if there is an issue or if the features have been removed and the documentation poorly maintained.

I will escalate this to Google.

For collective management, other enquiries describing the same type of issue will be merged to this one.

⚠️ ATTENTION (For anyone who has encountered this issue) ⚠️

The volunteers in this forum are not always able to help with troubleshooting issues like this, so this issue has been escalated to Google, and the Google development/engineering team is very aware of the situation.

Please click I have the same question, and 👍 Upvote.
Please, also click Subscribe if you want to be notified of updates.
Google developers/engineers do NOT read these forums, so posting a"me too" or "+1" reply only result in a waste of time.
The issues reported in the OPENING ENQUIRY post are tracked by views and upvotes, not by the number of "me too" or "+1" replies.
Please only post a reply that provides some detailed information that can help identify the cause and lead to a solution to the problem. (eg. device brand/type, type of operating system, operating system version numbers, browser/software version numbers, solutions you have discovered, etc).
Updates will be posted AFTER Google developers/engineers report the issue is fixed or that a fix is being rolled out.