Forum Discussion
How to add vertical line to existing chart?
Please take a look at the attached screenshot, mainly I just have 2 columns, strike price and OI. I used insert recommended chart, the clustered column chart is the one that looks best for me. I just wanted to dynamically add a vertical line to the chart with whatever the current price is (430.5). I tried to follow few examples online but my chart always look messed up after I try to add the vertical line. Any suggestions or help?
I'd use an XY Scatter chart, since its x-axis is scalar (numeric) instead of categorical.
Sample workbook attached.
I appreciate the quick reply and did get it to work with the example you provided. I guess there's no easy way to get it to work with the clustered column?
No, not really, since the x-axis of a column chart is not numerical.
