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

[jhorvath]

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

 

[Barb Reinhardt]

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

 

[Andy Pope]

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

Cheers
Andy

 

[Jon Horvath]

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