Is there a procedure for doing this in Libreoffice calc, similar to this one for MS office?
I found this procedure for MS Office: How to add a vertical line to the chart - Microsoft Excel 2016
Anything like this out there for Libreoffice?
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.
test.ods
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…
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.
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.
If this answer is correct for you, please click the check mark in front of your question.
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.
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?
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…
Here is a (not very elegant) work-around that resolved the issue for me:
- make the chart area 100% transparent;
- format one edge of a column of cells behind the chart;
- Adjust the position of the cells and chart to situate the line where you want it.
This will give you a line that appears to be on the graph/plot, but that is actually behind it.