| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding lines of data to an area chart | Excel Discussion (Misc queries) | |||
| Adding a horizontal line to a stock chart | Charts and Charting in Excel | |||
| Provide a "high/low" chart (stock chart) in horizontal mode | Charts and Charting in Excel | |||
| Horizontal lines in waterfall chart | Charts and Charting in Excel | |||
| Want to combine columns and horizontal lines in complex chart - Can it be Done?! | Charts and Charting in Excel | |||
Linear Mode
