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.
- 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!
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.
- Find Text and copy another cells
- COUNTIFS WITHIN DATE RANGE GOOGLE SHEET
- conditional formatting on a single cell where criteria is another column [solved]
- Lookup by Table With ARRAYFORMULA
- GoogleFinance: Return Data Without Column Header
- Number of days between two dates excluding Sunday in Google Sheets
- How to unpivot data that has multiple column groups in Google Sheets?
- google script Prevent duplicate data Submit
- Populate new columns with a header value
- Generate all lines in table when one cell contains several values
- Pickup n columns following a pattern
- How do I do basic date grouping operations in Google Sheets?
- How can I check if a numerical value is within a range of cells in google sheets?
- How to utilize date add function in Google spreadsheet?
- SUM on google sheet always returns 0
- Google Script To Copy row based on Drop down, Not working
- Trouble updating borders in Google Spreadsheet via C#
- Adding clause of and/or to if statement
- How do I use offset within a forEach loop in google apps script
- How to use date with LIKE inside query?
- Remove empty rows in Google Sheets
- Export a Google Sheet to PDF file with Python requests
- Formula to convert matrix to rows in Google Sheets
- Google scripts on execution below code giving error as "exceeded maximum time"
- Attaching Files from Google Drive to Email sent in Google Sheets
- How to GetSheetByName using partial string in google apps script
- How to unnest data from one column to fit the entire dataset - Google Sheets
- Google Sheet Function Not Working as Expected
- How to use Google Cloud ADC to access Google Drive API from Python with personal account (not service account)
- How do I center my pdf download using app script?