Ask Your Question
0

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

Comments

LibreOffice_Calc_Guide,
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
0

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

Comments

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

Stats

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

Seen: 9,917 times

Last updated: Sep 21 '14