Adding Horizontal Lines to a stock chart

[Bondonian]

How do I add horizontal lines to a stock chart using vba? What i am trying
to do is this: I am pulling historical stock data for a certain time frame
and displaying it in an excel stock bar chart. I also have levels which i
want to display on this chart, but can not figure out a way to do it. Does
anyone have any suggestions?

Thanks!
Mike

 

[Jon Peltier]

Combine these two methods:

http://peltiertech.com/Excel/Charts/AddLine.html
http://peltiertech.com/Excel/Charts/StockChartPlus.html

- Jon

 

[Bondonian]

Can these methods be done programatically through VBA?

Thanks Jon!

 

[Jon Peltier]

Sure. Turn on the macro recorder while you do it once to get some started
code.

- Jon