Adding Horizontal Lines to a stock chart
 

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

Adding Horizontal Lines to a stock chart
 

Combine these two methods:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Bondonian" wrote in message
...
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

Adding Horizontal Lines to a stock chart
 

Can these methods be done programatically through VBA?

Thanks Jon!

"Jon Peltier" wrote:

Combine these two methods:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Bondonian" wrote in message
...
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

Adding Horizontal Lines to a stock chart
 

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Bondonian" wrote in message
...
Can these methods be done programatically through VBA?

Thanks Jon!

"Jon Peltier" wrote:

Combine these two methods:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Bondonian" wrote in message
...
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