Is there a way to create a standard OHLC bar chart in Excel?

Hi,

Does anyone know if it is possible to create a standard open high low
close bar chart in Excel? I don't want the candlestick form they have but
rather a format similar to the high-low-close included in Excel that also
uses the open price. I want the bars to look something like:

|
|_
|
_|
|


Thank you in advance for your help,

Jon

http://www.peltiertech.com/Excel/Charts/stock.html

"jhorvath@cfxasset.com" <jhorvath@cfxasset.com@discussions.microsoft.com>
wrote in message news:A4A48B44-A88D-445D-9D37-C1248D44AB15@microsoft.com...
> Hi,
>
> Does anyone know if it is possible to create a standard open high low
> close bar chart in Excel? I don't want the candlestick form they have but
> rather a format similar to the high-low-close included in Excel that also
> uses the open price. I want the bars to look something like:
>
> |
> |_
> |
> _|
> |
>
>
> Thank you in advance for your help,
>
> Jon

Hi,

It's a little hard to tell from your diagram but have a look at Jon's
stock chart examples.
http://peltiertech.com/Excel/Charts...ftTickOpen.html

Cheers
Andy

jhorvath@cfxasset.com wrote:

> Hi,
>
> Does anyone know if it is possible to create a standard open high low
> close bar chart in Excel? I don't want the candlestick form they have but
> rather a format similar to the high-low-close included in Excel that also
> uses the open price. I want the bars to look something like:
>
> |
> |_
> |
> _|
> |
>
>
> Thank you in advance for your help,
>
> Jon

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Thank you Barb and Andy,

That's what I was looking for. I wonder why this isn't an automatic
option in Excel to begin with....

Jon

"Andy Pope" wrote:

> Hi,
>
> It's a little hard to tell from your diagram but have a look at Jon's
> stock chart examples.
> http://peltiertech.com/Excel/Charts...ftTickOpen.html
>
> Cheers
> Andy
>
> jhorvath@cfxasset.com wrote:
>
> > Hi,
> >
> > Does anyone know if it is possible to create a standard open high low
> > close bar chart in Excel? I don't want the candlestick form they have but
> > rather a format similar to the high-low-close included in Excel that also
> > uses the open price. I want the bars to look something like:
> >
> > |
> > |_
> > |
> > _|
> > |
> >
> >
> > Thank you in advance for your help,
> >
> > Jon
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
>