DashboardNovice
Member
In the attached file, I am trying to plot column F (Strike Price) as a vertical line, so a vertical line at $20, but it's coming out horizontal. I changed it to XY Scatter and it is still horizontal, only much higher.
I also tried creating a separate table just for the vertical line with (X,Y) values of (20,10) and (20,30) and this didn't work. Then when I right click > Select Data Source, my new data series has the X coordinates from column D values, instead of X coordinates of 20 and 20 again. If I right click > Select Data Source again, then edit the horizontal axis for my new data series and select 20 and 20 from my new table, this changes the X axis not just for the new data series I am editing, but for all data series.
I'm fairly sure I didn't this many years ago, but I can't remember how I did this.
What is the best way to plot a vertical line?
I also tried creating a separate table just for the vertical line with (X,Y) values of (20,10) and (20,30) and this didn't work. Then when I right click > Select Data Source, my new data series has the X coordinates from column D values, instead of X coordinates of 20 and 20 again. If I right click > Select Data Source again, then edit the horizontal axis for my new data series and select 20 and 20 from my new table, this changes the X axis not just for the new data series I am editing, but for all data series.
I'm fairly sure I didn't this many years ago, but I can't remember how I did this.
What is the best way to plot a vertical line?