+ Reply to Thread
Results 1 to 4 of 4

Adding vertical lines to line chart in Excel 2016?

  1. #1
    Registered User
    Join Date
    01-17-2017
    Location
    United Kingdom
    MS-Off Ver
    Office 365
    Posts
    42

    Question Adding vertical lines to line chart in Excel 2016?

    Such as the red lines I added in Paint in the image attached

    I simply can't find the option.
    Attached Images Attached Images

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Adding vertical lines to line chart in Excel 2016?

    Cross-posted at:
    https://www.mrexcel.com/forum/excel-...el-2016-a.html
    http://www.msofficeforums.com/excel/...el-2016-a.html
    https://www.neowin.net/forum/topic/1...in-excel-2016/

    For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
    Please also read:
    Excel Forum's Cross-Posting policy in rule #8: http://www.excelforum.com/forum-rule...rum-rules.html
    Mr Excel's policy on Cross-Posting in rule #13: http://www.mrexcel.com/forum/board-a...rum-rules.html
    Last edited by macropod; 04-07-2017 at 03:19 AM.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,819

    Re: Adding vertical lines to line chart in Excel 2016?

    I don't think there is a built in option to find, but one of these techniques should work: http://peltiertech.com/Excel/Charts/AddLine.html
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Adding vertical lines to line chart in Excel 2016?

    I hope this time you will be courteous enough to acknowledge the given answers (and perhaps even thank the person you get help from), which is a thing you never seem to do, be it on MrE, Msoffice or here

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Adding secondary vertical axis to chart in Excel 2010
    By funkmeister79 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-26-2014, 01:28 PM
  2. Vertical lines on a chart?
    By ryanjb in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-25-2013, 05:38 AM
  3. Vertical Lines - Area Chart
    By negcx in forum Excel General
    Replies: 3
    Last Post: 12-30-2008, 07:29 AM
  4. Add 2 vertical lines to bar chart
    By thei in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-25-2008, 04:38 PM
  5. Adding vertical lines to a chart which has a data table
    By ultra vires in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 10-11-2007, 05:54 PM
  6. [SOLVED] Vertical lines in a line chart
    By Enna in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 08-01-2006, 07:10 AM
  7. Automatically adding Vertical lines after certain points in line graph
    By matthoffman33 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-06-2006, 09:50 PM
  8. Replies: 3
    Last Post: 03-03-2006, 12:20 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1