• 0

Adding vertical lines to line chart in Excel 2016?


Question

Such as these red lines I added in Paint:

 

eb_vertlines1.thumb.png.258c6cd29812e8bee84c820f78c0be73.png

 

I simply can't find the option :/

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

Assuming this is a recent version of Excel

 

  1. Highlight your chart or data series
  2. On the Design ribbon, select 'Add Chart Element' (top left)
  3. Select 'Lines' > 'Drop Lines'

https://support.office.com/en-gb/article/Add-or-remove-series-lines-drop-lines-high-low-lines-or-up-down-bars-in-a-chart-29139b09-ce6a-49ad-95e4-447562a22260

 

HTH.

Link to comment
Share on other sites

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.