Impossible to set a max/min range on x-axis chart

Hello, I created a chart and I want to change the x-axis range… So as usual I selected “x-axis” format selection and scale, but as you can see there’s no option to set a max-min value:

Anyone can help? Thank’s

You are attempting to change X-axis range on a Column type chart, that won’t work (unless X-axis values are of type Dates). Use a proper X-Y chart instead.

What if I want columns?

Hide the data rows.
88212.ods (41.9 KB)

2 Likes

Nice! How did you produced that “collapsable” section? It’s way more convenient than select everytime the rows and hit “hide rows”.

Select the cells to be hidden and call menu:Data>Group>Group (key F12)

1 Like

Nice :slight_smile: thank you