Excel 2016: Creating Charts and Diagrams In Excel 2016, charts and diagrams can show trends, averages, high and low points, and more. Not only do they make your worksheets more visually appealing, they also serve a definite function.
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.
Unfortunately, this isn't working. I added Error Bars and chose More Options.
![How to add vertical lines in excel How to add vertical lines in excel](/uploads/1/2/5/5/125510349/561540008.png)
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. Buggy program?