Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 2nd 04, 06:43 PM
 
Posts: n/a
Default 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

  #2   Report Post  
Old December 2nd 04, 09:03 PM
Barb Reinhardt
 
Posts: n/a
Default

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



  #4   Report Post  
Old December 2nd 04, 09:49 PM
Jon Horvath
 
Posts: n/a
Default

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Chart appearance using "export" method Alex St-Pierre Charts and Charting in Excel 4 December 3rd 04 03:29 AM
How do I create a custom scroll bar on a 3D Pivot Chart? JRW in Idaho Charts and Charting in Excel 1 December 1st 04 08:55 PM
Chart newbie help, please, How to create JohnT Charts and Charting in Excel 3 November 30th 04 04:17 PM
Is there an interpolation-function in Excel to read a chart more . BM Charts and Charting in Excel 1 November 29th 04 02:19 PM
Why do my text boxes disappear from my chart when I click out? Robboo Charts and Charting in Excel 1 November 27th 04 05:49 PM


All times are GMT +1. The time now is 04:10 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017