adding vertical lines to calc scatter plots

edit

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..