Editing the range of Y axis in a Chart in Open Office SpreadSheet

First right click on the chart select Edit.

Second right click on the Y Axis number and select Format Axis.

Third the box you needed gets opened.