Ask Your Question

adding vertical lines to calc scatter plots

asked 2018-08-22 06:33:32 +0200

this post is marked as community wiki

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

Is there a procedure for doing this in Libreoffice calc, similar to this one for MS office?

I found this procedure for MS Office:

Anything like this out there for Libreoffice?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-08-22 09:24:21 +0200

JBF gravatar image

Did you try to do the same thing, that is adding an error bar? It works in Calc too but I prefer my own solution that is to add a data series with 2 points (x1,y1) and (x1,y2): same x1 for both and and 2 different values y1 and y2.

Here is an example in which the abscissa of the vertical line is chosen in a dropdown list and the y1 and y2 is computed from the min and max y-value of the main data series. C:\fakepath\test.ods

edit flag offensive delete link more


I was able to duplicate what you've done (which is really cool) except for the label traveling with the vertical line. The value statement is sitting in the legend, stationary. How did you set that part up? By the way, thanks for this, it's exactly what I'm trying to do..

mlytle0 gravatar imagemlytle0 ( 2018-08-22 17:12:39 +0200 )edit

O.K. A couple of hours later, looking around the web, I'm almost there, I have the same thing now as you, but label is at the bottom of the vertical line, not the top. Working on it.

mlytle0 gravatar imagemlytle0 ( 2018-08-22 19:59:14 +0200 )edit

There is 2 labels in column E, the first is empty, the second corresponds to the max value in column D (y-axis for the vertical line). The value in the legend is D1 which refers to label E3.

JBF gravatar imageJBF ( 2018-08-22 22:26:39 +0200 )edit

If this answer is correct for you, please click the check mark in front of your question.

JBF gravatar imageJBF ( 2018-08-22 22:28:25 +0200 )edit

I got mine to work identically to yours by flipping D2 and D3, putting the positive value on top, so I'm still not sure how you got yours to do that with the order the way you have it. I think I'm still missing something, but I'll keep playing with it.

mlytle0 gravatar imagemlytle0 ( 2018-08-22 23:42:29 +0200 )edit

I'm looking for a check mark, all I see is options, one of which is 'close', along with retag, edit and delete. Is that what I do?

mlytle0 gravatar imagemlytle0 ( 2018-08-22 23:48:08 +0200 )edit

Looking around, I don't see where I can up vote anyone or mark this question as answered. This website is very poorly labeled as to options. I'm wary of randomly clicking things here that aren't clear, so if someone else wants to mark this as settled, they are welcome to do so..

mlytle0 gravatar imagemlytle0 ( 2018-08-23 00:30:26 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-08-22 06:33:32 +0200

Seen: 2,613 times

Last updated: Aug 23 '18