Stock Bar Charts

[Akistner]

how do I add the "open" to a stock bar chart in Excel?

 

[Jon Peltier]

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/StockChartLeftTickOpen.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]

Thank you - exactly what I was looking for!!

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/StockChartLeftTickOpen.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/
_______