x axis scale using numbers/max/min/minor/major data entered by me - i.e. not automatic. How?

" For some types of axes, you can select to format an axis as text or date, or to detect the type automatically"

The scale options are “automatic”, which, as expected, has no options, “text” which, surprisingly, has no options and “date” which has excel-like options - for dates.

Surely there should be a numbers category with the sort of options I get in Excel for formatting max, min, major, minor etc - for numbers?

It’s a stacked bargraph, accordimg to Excel, by the way, with each bar accumulating about a dozen values. Looks absolutely right in Excel, just a mess in LibreOffice Calc