Adding vertical lines to line chart in Excel 2016?

[King Mustard]

Such as these red lines I added in Paint:

I simply can't find the option.

 

[Macropod]

Cross-posted at:
https://www.excelforum.com/excel-ch...ical-lines-to-line-chart-in-excel-2016-a.html
Adding vertical lines to line chart in Excel 2016?
https://www.neowin.net/forum/topic/1327456-adding-vertical-lines-to-line-chart-in-excel-2016/

For cross-posting etiquette, please read: Excelguru Help Site - A message to forum cross posters
Please also read:
Excel Forum's Cross-Posting policy in rule #8: Forum Rules
Mr Excel's policy on Cross-Posting in rule #13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

 

[DRSteele]

Strangely enough, I saw three videos on something like this the other day. I think you will want to add error bars.

Watch this and the subsequent two from the ExcelIsFun channel on youtube and let us know if they're germane.

https://www.youtube.com/watch?v=yTRm-voT8WQ

 

[King Mustard]

Strangely enough, I saw three videos on something like this the other day. I think you will want to add error bars.

Watch this and the subsequent two from the ExcelIsFun channel on youtube and let us know if they're germane.

https://www.youtube.com/watch?v=yTRm-voT8WQ

Unfortunately, this isn't working.

I added Error Bars and chose More Options... then I selected 'Minus' (as he did). So far, so good.

I then clicked Custom and Specify Value and removed the entries from both text boxes but whereas his lines stayed, mine totally disappeared, so I can not select them to change colors etc. as he did.

Buggy program?

 

[DRSteele]

You must have failed to put the range into the 'Negative Error Values' box.