Stock Bar Charts
how do I add the "open" to a stock bar chart in Excel?
|
Stock Bar Charts
In the OHLC type candlestick charts, Open and Close define the top and
bottom of the up-down bars. Excel doesn't offer the commonly used left-tick for open, just the right tick for close. I have one technique to simulate this on my web site: http://peltiertech.com/Excel/Charts/...tTickOpen.html and I have since developed a much easier technique, which I have yet to write up. Sometime soon, perhaps. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Akistner" wrote in message ... how do I add the "open" to a stock bar chart in Excel? |
Stock Bar Charts
Thank you - exactly what I was looking for!!
"Jon Peltier" wrote: In the OHLC type candlestick charts, Open and Close define the top and bottom of the up-down bars. Excel doesn't offer the commonly used left-tick for open, just the right tick for close. I have one technique to simulate this on my web site: http://peltiertech.com/Excel/Charts/...tTickOpen.html and I have since developed a much easier technique, which I have yet to write up. Sometime soon, perhaps. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Akistner" wrote in message ... how do I add the "open" to a stock bar chart in Excel? |
All times are GMT +1. The time now is 05:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com