Setting min max values for the Horizontal Axis on a Google Sheets chart
I have a google sheet with an embedded chart. I am able to add min/max values that display on the chart for the vertical axis, but not the horizontal.
Here are the details for the verticle axis:
But I don't have min/max options for the horizontal axis:
What am I missing?
Solution
The Min-Max option will only appear if the defined X-axis range contains only numeric values:
I was able to reproduce this with a sample table. My X-axis range is A3:A6.
When numeric values are used for the X-axis range:
- Google sheets: Create function that calculates depending on dropdown menu text
- Parse JSON import data string into two columns
- Transfer data with GOOGLE SHEETS
- shortest formula to get the last non zero value from column
- Selecting the last value of a column
- Adjusting A Script That Deletes Duplicates On Other Sheets
- Adding a hyperlink to an inline image on Google Appscript
- Setting min max values for the Horizontal Axis on a Google Sheets chart
- How to match invisible new lines?
- convert two columns containing group and items in group into a single column
- QUERY function to create pivot table with strings
- Remove lines from text in a cell that match a set of words
- how to construct and write a formula to google sheets to perform a dynamic date calculation
- Trying to update Google Sheet data with Python (mathematical expression), but apostrophe keep coming out
- Copy certain cells over to another sheet when the script is running
- google sheets, conditional formatting based on row numbers
- How to prepare string to paste in multiple Google Sheets cells skipping some cells?
- Sorting by Custom Array
- Getting an Undefined Value error in Google Script Function
- Which function runs when there are multiple script projects bound to the same Google Sheet?
- Bringing up data from another SpreadSheet with arrayformula, query and importrange
- Count number of pairs, triplets, etc in a google spreadsheet
- How to get current active/triggered trigger ID ,
- Remove duplicate values from text, ignoring case (keeping original)
- Google App Script - Json response parsing
- How to ignore hidden rows?
- Using INDIRECT in Google Sheets to reference to reference a table's named column
- Run a function published in Webapp from a Google site
- Querying a Google Sheet API using GViz
- Google Sheets query, calculate time