Stock Bar Charts

how do I add the "open" 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:

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" <Akistner@discussions.microsoft.com> wrote in message
news:03710545-ADB9-4F40-A2A9-D0D2D8E4AA34@microsoft.com...
> how do I add the "open" to a stock bar chart in Excel?

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" <Akistner@discussions.microsoft.com> wrote in message
> news:03710545-ADB9-4F40-A2A9-D0D2D8E4AA34@microsoft.com...
> > how do I add the "open" to a stock bar chart in Excel?
>
>
>