Hi,
It would be nice to be able to control the min-value of a Y-axis of a common chart. Here are two results from the same data, with two extremes. Is there any way to specify a min-value for the Y-axis?
To start with , you may wish to go through the following recent announcement
Could you please add what you wish to implement, a value starting from 0 or some such minimum value in the line chartโs Y axis? I believe a line chartโs minimum Y axis settles down to minimum value in the chart
In that case, one not so elegant workaround could be to have one value of 0 or the desired minimum value permanently in a row or another column and to include that row in the slice of the chart. However wherever this minimum value is in the slice( beginning or end), it will appear there in the chart and the chart could look a bit odd, if next value is very high.
If it is a different column, the zero ( or minimum) value will show across all data points.
Thank you @Suvrutt_Gurjar . In the above charts I posted (same data), I would have chosen something like 9 to have given a bit of bottom โpaddingโ in the case of the line chart to make it less erratic and to reduce the excessive length of the histogram bars to make the series more pronounced. Fingers crossed for the new charts. This isnโt a radical notion and really should be in any charting app (IMHO). Itโs usually done with a โzig-zagโ near the bottom of the axis to highlight that it doesnโt start at zero, which Iโm sure weโre all aware of.
Thank you for the hack ideas. Iโll see whatโs best.
Got it. I am sure the new charting engine from AppSheet will be much feature rich and powerful.
User | Count |
---|---|
60 | |
25 | |
13 | |
12 | |
6 |