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
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1