Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenThu, 23 Aug 2018 00:30:26 +0200adding vertical lines to calc scatter plotshttps://ask.libreoffice.org/en/question/163497/adding-vertical-lines-to-calc-scatter-plots/ Is there a procedure for doing this in Libreoffice calc, similar to this one for MS office?
I found this procedure for MS Office: https://www.officetooltips.com/excel_2016/tips/how_to_add_a_vertical_line_to_the_chart.html
Anything like this out there for Libreoffice?Wed, 22 Aug 2018 06:33:32 +0200https://ask.libreoffice.org/en/question/163497/adding-vertical-lines-to-calc-scatter-plots/Answer by JBF for <p>Is there a procedure for doing this in Libreoffice calc, similar to this one for MS office?</p>
<p>I found this procedure for MS Office: <a href="https://www.officetooltips.com/excel_2016/tips/how_to_add_a_vertical_line_to_the_chart.html">https://www.officetooltips.com/excel_...</a></p>
<p>Anything like this out there for Libreoffice?</p>
https://ask.libreoffice.org/en/question/163497/adding-vertical-lines-to-calc-scatter-plots/?answer=163504#post-id-163504Did 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](/upfiles/15349226182237953.ods) Wed, 22 Aug 2018 09:24:21 +0200https://ask.libreoffice.org/en/question/163497/adding-vertical-lines-to-calc-scatter-plots/?answer=163504#post-id-163504Comment by mlytle0 for <p>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.</p>
<p>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.
<a href="/upfiles/15349226182237953.ods">C:\fakepath\test.ods</a> </p>
https://ask.libreoffice.org/en/question/163497/adding-vertical-lines-to-calc-scatter-plots/?comment=163554#post-id-163554I 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..Wed, 22 Aug 2018 17:12:39 +0200https://ask.libreoffice.org/en/question/163497/adding-vertical-lines-to-calc-scatter-plots/?comment=163554#post-id-163554Comment by JBF for <p>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.</p>
<p>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.
<a href="/upfiles/15349226182237953.ods">C:\fakepath\test.ods</a> </p>
https://ask.libreoffice.org/en/question/163497/adding-vertical-lines-to-calc-scatter-plots/?comment=163587#post-id-163587There 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.Wed, 22 Aug 2018 22:26:39 +0200https://ask.libreoffice.org/en/question/163497/adding-vertical-lines-to-calc-scatter-plots/?comment=163587#post-id-163587Comment by JBF for <p>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.</p>
<p>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.
<a href="/upfiles/15349226182237953.ods">C:\fakepath\test.ods</a> </p>
https://ask.libreoffice.org/en/question/163497/adding-vertical-lines-to-calc-scatter-plots/?comment=163588#post-id-163588If this answer is correct for you, please click the check mark in front of your question.Wed, 22 Aug 2018 22:28:25 +0200https://ask.libreoffice.org/en/question/163497/adding-vertical-lines-to-calc-scatter-plots/?comment=163588#post-id-163588Comment by mlytle0 for <p>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.</p>
<p>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.
<a href="/upfiles/15349226182237953.ods">C:\fakepath\test.ods</a> </p>
https://ask.libreoffice.org/en/question/163497/adding-vertical-lines-to-calc-scatter-plots/?comment=163596#post-id-163596I'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?Wed, 22 Aug 2018 23:48:08 +0200https://ask.libreoffice.org/en/question/163497/adding-vertical-lines-to-calc-scatter-plots/?comment=163596#post-id-163596Comment by mlytle0 for <p>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.</p>
<p>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.
<a href="/upfiles/15349226182237953.ods">C:\fakepath\test.ods</a> </p>
https://ask.libreoffice.org/en/question/163497/adding-vertical-lines-to-calc-scatter-plots/?comment=163595#post-id-163595I 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.Wed, 22 Aug 2018 23:42:29 +0200https://ask.libreoffice.org/en/question/163497/adding-vertical-lines-to-calc-scatter-plots/?comment=163595#post-id-163595Comment by mlytle0 for <p>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.</p>
<p>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.
<a href="/upfiles/15349226182237953.ods">C:\fakepath\test.ods</a> </p>
https://ask.libreoffice.org/en/question/163497/adding-vertical-lines-to-calc-scatter-plots/?comment=163597#post-id-163597Looking 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..Thu, 23 Aug 2018 00:30:26 +0200https://ask.libreoffice.org/en/question/163497/adding-vertical-lines-to-calc-scatter-plots/?comment=163597#post-id-163597Comment by mlytle0 for <p>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.</p>
<p>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.
<a href="/upfiles/15349226182237953.ods">C:\fakepath\test.ods</a> </p>
https://ask.libreoffice.org/en/question/163497/adding-vertical-lines-to-calc-scatter-plots/?comment=163574#post-id-163574O.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.Wed, 22 Aug 2018 19:59:14 +0200https://ask.libreoffice.org/en/question/163497/adding-vertical-lines-to-calc-scatter-plots/?comment=163574#post-id-163574