So I am trying to insert a vertical line in my graph in Google Sheets, by following the solution given here:

I want the line to go from point 25;0 to point 25;0.00000085, but instead it goes from 0;0 to 2;0.00000085. It's the yellow line in the picture. Could someone help me? I'm losing my mind over this. (In the solution posted above they say that the extra x values should be added at the top of the column but when I do that the graph just gets even more fucked up.)

enter image description here

1 Answer 1


Group each series of values together rather than creating a mix of the series.

Do this


Don't do this



The chart and its setup should look like this: chart

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.