Add vertical line to Excel chart: ster plot, bar and ...
· A vertical line appears in your Excel bar chart, and you just need to add a few finishing touches to make it look right. Doubleclick the secondary vertical axis, or rightclick it and choose Format Axis from the context menu:; In the Format Axis pane, under Axis Options, type 1 in the Maximum bound box so that out vertical line extends all the way to the top.