software

how do I add the quot;openquot; to a stock bar chart in Excel?

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:

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
PeltierTech.com/
_______quot;Akistnerquot; gt; wrote in message
...
gt; how do I add the quot;openquot; to a stock bar chart in Excel?
Thank you - exactly what I was looking for!!

quot;Jon Peltierquot; wrote:

gt; In the OHLC type candlestick charts, Open and Close define the top and
gt; bottom of the up-down bars.
gt;
gt; Excel doesn't offer the commonly used left-tick for open, just the right
gt; tick for close. I have one technique to simulate this on my web site:
gt;
gt; peltiertech.com/Excel/Charts/...tTickOpen.html
gt;
gt; and I have since developed a much easier technique, which I have yet to
gt; write up. Sometime soon, perhaps.
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services
gt; Tutorials and Custom Solutions
gt; PeltierTech.com/
gt; _______
gt;
gt;
gt; quot;Akistnerquot; gt; wrote in message
gt; ...
gt; gt; how do I add the quot;openquot; to a stock bar chart in Excel?
gt;
gt;
gt;