You can write your own “Autoscale” macro just calculate and set the min/max values of the axes based on the data cell range. And you can assign the maco some event or context menu of the chart.
For me, in a chart, white space is part of data. See you.
When I create a Stock Chart 1 in LO Calc 8.3.2 from a range having dates in the first column and Low, High, Close values in the adjacent columns, I have similar problems with the Y-axis scaling. In fact, sometimes the Y-axis scale doesn’t make any sense at all.
Solution:
Simply changing the X-axis Scale to Text (from either Automatic or Date) results in the Y-axis scaling perfectly with reasonable minimum and maximum values. Note: This seems to work correctly for only up to 29 dates (ie. rows of data). When the chart is set to display 30 or more dates, the Y-Axis reverts to zero-based.