• 0

Adding vertical lines to line chart in Excel 2016?

Asked by Elliot B.,

 Share

Question

1 answer to this question

Recommended Posts

  • 0
Grand Master

spikey_richie

Posted
Posted

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.

This topic is now closed to further replies.
 Share
Go to question listing

  • Recently Browsing   0 members

    • No registered users viewing this page.

  • Posts

    • That sharp cold toothache you dread? Its origins trace back to ancient, unexpected purpose

      By neufuse · Posted

      yeah... I'm gonna say this aint tech news either, don't turn this site into the verge......
    • Court orders Apple to keep web links in the App Store, eroding its iOS payment monopoly

      By Dutchie64 · Posted

      But... but... Think of the shareholders.....
    • Microsoft makes it easier to find PC specs in Windows 11 Settings

      By ESC@PE · Posted

      Right Click on My Computer Icon -> Properties(?)
    • HomeBank 5.9.2

      By Copernic · Posted

      HomeBank 5.9.2 by Razvan Serea HomeBank is a free software (as in "free speech" and also as in "free beer") that will assist you to manage your personal accounting. It is designed to easy to use and be able to analyse your personal finance and budget in detail using powerful filtering tools and beautiful charts. If you are looking for a completely free and easy application to manage your personal accounting, budget, finance then HomeBank should be the software of choice. HomeBank also benefits of more than 19 years of user experience and feedback, and is translated by its users in around 56 languages. Highlights: Cross platform, supports GNU/Linux, Microsoft Windows, Mac OS X Import easily from Intuit Quicken, Microsoft Money or other software Import bank account statements (OFX, QIF, CSV, QFX) Duplicate transaction detection Automatic cheque numbering Various account types : Bank, Cash, Asset, Credit card, Liability Scheduled transaction Category split Internal transfer Month/Annual budget Dynamic powerful reports with charts Automatic category/payee assignment Vehicule cost HomeBank 5.9.2 fixes: bugfix: #2112135 scheduled with limitation don't stop and goes erroneous data bugfix: #2111663 variable scope issue in ui-assign.c bugfix: #2111359 remind status not synced in transfers Download: HomeBank 5.9.2 | 20.2 MB (Open Source) Download: 3rd party packages (macOSX. Ubuntu...etc) View: HomeBank Website | Support | Features | Screenshot Get alerted to all of our Software updates on Twitter at @NeowinSoftware
    • The official Funny Pictures thread

      By snowy owl · Posted

  • Recent Achievements

    • Week One Done
      jbatch earned a badge
      Week One Done
    • First Post
      Yianis earned a badge
      First Post
    • Rookie
      GTRoberts went up a rank
      Rookie
    • First Post
      James courage Tabla earned a badge
      First Post
    • Reacting Well
      James courage Tabla earned a badge
      Reacting Well

  • Popular Contributors

    1. 1
      +primortal
      400
    2. 2
      +FloatingFatMan
      178
    3. 3
      snowy owl
      171
    4. 4
      ATLien_0
      169
    5. 5
      Xenon
      134
    Show More

  • Tell a friend

    Love Neowin? Tell a friend!