Adding a vertical line on a line graph?

[DashboardNovice]

In the attached file, I am trying to graph the Strike Price (purple) as a vertical dashed bar at $105. It is coming out horizontal.

Is this possible?

 

[NARAYANK991]

Hi ,

Can you go through this link , and implement the technique yourself ?

http://peltiertech.com/Excel/Charts/AddLineVertSeries.html

Narayan

 

[p45cal]

Try changing you chart type to XY Scatter, then add a row in the chart's source data so that the strike price shows up twice, add a column and put max and min values against the 2 strike prices, plot the additional column as an additional series.
See attached.

 

[DashboardNovice]

Thank you everybody. So now I have a vertical line on a secondary axis. But I don't want the axis to show. If I disable it from the Layout tab, my vertical line also goes away with the secondary axis

How can I retain the vertical line and remove the secondary axis?

 

[NARAYANK991]

Hi ,

You don't need to disable it ; you can remove displays of the markers and labels.

Narayan

 

[p45cal]

How can I retain the vertical line and remove the secondary axis?

My offering doesn't have a secondary axis so there's nothing to remove.