My own stock chart with open/close same level?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have made my own stock chart (or candle chart) with high,low,open close...
When my open and close are at the same level... I just get a line for the
highs and lows but no "body" to my candle... how can I get some sort of
indication where the open and the close simotaneously happened?

Any thoughts are appreciated
 
Well, I made my own candle chart so I could format the body with 3 different
colors... so I want to keep the candle in place. Did I miss understand you
that you were suggesting moving to a different style of graph?
 
I guess you didn't follow the link. In it I show how to create the more
common style of stock chart with tick marks to either side for open and
close. The built-in candlestick chart draws a horizontal line even if open =
close, which I didn't know until I just tested it. You could draw another
series for cases in which open = close, and use a particular marker for
these.

- Jon
 
Thanks for the thoughts

Jon Peltier said:
I guess you didn't follow the link. In it I show how to create the more
common style of stock chart with tick marks to either side for open and
close. The built-in candlestick chart draws a horizontal line even if open =
close, which I didn't know until I just tested it. You could draw another
series for cases in which open = close, and use a particular marker for
these.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
Click to expand...
 
Back
Top