Having stock chart to draw many individual straight line

Hi all,

I have stock chart with candlestick bar and a few of smooth line.
That means I have utilize both axes and cant add any new Y values.
If I do, it will change secondary axes too.

Now I have this new set of data that need to be incorporate into the chart.
As above described, I have try a lot of method and some really not that good and inconveniences.

Is there a way to add many individual straight line in the same chart? Straight line refers to line connecting two points and can be in any direction and length.

If can be done with vba, I am happy with it.

Any suggestion is appreciated.

Thanks.

Book1.xlsx

Just add another line in the same way as you did the other 2.

In order to have breaks in the line you will need to have empty cells.

only other way is to create the chart yourself and by that I mean use stacked column chart to produce the floating columns and xy-scatter for the lines.

You can use 3 series with NA() formula before and after each line segment.