We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

How to get values from 100 to 2000 on secondary Y axis? [closed]

asked 2014-01-07 17:39:00 +0200

altair gravatar image

updated 2014-01-07 23:17:40 +0200

oweng gravatar image
edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-18 11:13:06.959822


Please provide more info. Can you post some sample data and explain what would you like to do? Also what is your LibreOffice version and what is your operating system name/version?

L-user gravatar imageL-user ( 2014-01-07 18:52:05 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2014-01-07 23:15:21 +0200

oweng gravatar image
  1. Right-click on the graph > Edit.
  2. Right-click on Secondary Y Axis > Format Axis... > Scale tab
    • Uncheck Automatic option against Minimum and enter "100".
    • Uncheck Automatic option against Maximum and enter "2000".
    • Uncheck Automatic option against Major interval and enter "100".
    • Click OK.
  3. Right-click on the smaller data series (e.g., the yellow line?) > Format Data Series... > Options tab > Align data series to select Secondary Y Axis > click OK.

For data like this (rename from JPG to ODS) the result should be similar to:

Secondary Y axis scale

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-01-07 17:39:00 +0200

Seen: 8,374 times

Last updated: Jan 07 '14