Thread
:
Is there a way to create a standard OHLC bar chart in Excel?
View Single Post
#
3
Andy Pope
Posts: n/a
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/...tTickOpen.html
Cheers
Andy
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
Reply With Quote