ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Is there a way to create a standard OHLC bar chart in Excel? (https://www.excelbanter.com/charts-charting-excel/54-there-way-create-standard-ohlc-bar-chart-excel.html)

[email protected] December 2nd 04 06:43 PM

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

Barb Reinhardt December 2nd 04 09:03 PM

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

"
wrote in message ...
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 December 2nd 04 09:16 PM

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

Jon Horvath December 2nd 04 09:49 PM

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



All times are GMT +1. The time now is 05:23 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
ExcelBanter.com