Ask Your Question

Control values on axes in line chart

asked 2018-08-16 19:08:59 +0100

blashrk gravatar image

I am trying to create a line chart with two columns in a calculate file. That works. But I cannot get the x axis to match with a third column from the same file. Nor can I control the range of values on the y-axis. How do I do that?

edit retag flag offensive close merge delete


If right-clicking on an axis does not bring up a dialog box with an entry for "Format Axis", then you will have to use an x-y (scatter) chart instead of a line chart. X-y (scatter) charts offer many features for formatting of the axes, including scaling of the axes, formatting of the of the labels, etc. Other things too.

ve3oat gravatar imageve3oat ( 2018-08-16 19:30:10 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-08-16 22:17:50 +0100

JBF gravatar image

Use X-Y chart. In a line chart, the abscissa is the row number if your data are given in column. With X-Y chart the first column is the abscissa and the second column is the ordinate.

edit flag offensive delete link more


Very helpful answer. Terse. Accurate. Solved what I needed to know. Thanks, JBF.

blashrk gravatar imageblashrk ( 2018-08-17 01:39:11 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-08-16 19:08:59 +0100

Seen: 192 times

Last updated: Aug 16 '18