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

Ask Your Question

how to adjust a x and y axis ranges on a chart created in Calc [closed]

asked 2014-09-19 18:27:18 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Libre Office 4, English, Calc charts

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-03-03 22:24:24.355491


Chapter 3 Creating Charts and Graphs

m.a.riosv gravatar imagem.a.riosv ( 2014-09-19 23:02:52 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2014-09-21 02:26:01 +0200

blindape gravatar image

To adjust chart ranges, you first need to be in chart edit mode.

  1. To edit an existing chart, either double - click on the chart or right-click on the chart and select Edit from the pop - up menu.
  2. Once in edit mode, right-click on the chart and choose Data Ranges... from the pop up menu.
  3. In the Data Ranges dialog box you can adjust settings for the entire data range in the Data Range tab or make customised adjustments in the Data Series tab.
  4. To modify a standard chart such as column or line in the Data Series tab, adjust the x-axis range with the Categories text box. Adjust the y-axis range by selecting Y-Values in the Data ranges: list then change the range in the Range for Y-Values text box.
  5. For an x-y scatter chart the x and y ranges appear as individual entries in the Data ranges: list. Select the item you wish to adjust from the list and then change the entry in the Range for... text box.

Cheers John

edit flag offensive delete link more


Thank you very much John! I was really helped by your description how to get to the popup menu for an existing chart (which does not score very high on my personal usability scale, but that is an issue for LibreOffice).

Freek de Bruijn gravatar imageFreek de Bruijn ( 2015-12-12 13:44:48 +0200 )edit

Question Tools

1 follower


Asked: 2014-09-19 18:27:18 +0200

Seen: 19,230 times

Last updated: Sep 21 '14