Having stock chart to draw many individual straight line

davidroger

New member
Joined
Dec 17, 2013
Messages
6
Reaction score
0
Points
0
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.
 
Here is an attachment for your reference.
 

Attachments

  • Book1.xlsx
    21 KB · Views: 22
Back
Top