+ Reply to Thread
Results 1 to 2 of 2

inserting vertical line on a line graph in excel 2010 help needed

  1. #1
    Registered User
    Join Date
    02-23-2011
    Location
    Cheshire, England
    MS-Off Ver
    Excel 2013
    Posts
    29

    inserting vertical line on a line graph in excel 2010 help needed

    I have a line chart that tracks the aggregate/cumulative profit and loss figures after each transaction, the horizontal axis just records the number of transactions as i add more transactions, the vertical axis records the cumulative profit and loss figures in £, all i want to to is add a vertical line at a couple of points on the chart, i have looked at google to try to help me with this but don't understand any of the answers .
    on the attached spreadsheet i need different coloured vertical lines at points 145 and 511 on the horizontal axis and an explanation on how to do this so i can do ity on other sheets i have, i am totally baffled on something that i assumed would be simple, thanks
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,476

    Re: inserting vertical line on a line graph in excel 2010 help needed

    Add another series.
    For each point you want a vertical line to appear for add a value of 1.

    Select the new series and move to the secondary axis.
    Set the secondary value axis to have Min=0 and Max=1.
    Add Minus Y Error bar to series. Set Error value to 1.
    Format error bar as required.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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