My own stock chart with open/close same level?

[John]

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

 

[Jon Peltier]

Try this approach instead:

http://peltiertech.com/Excel/ChartsHowTo/StockChartsAndLineChartTricks.html

- Jon

 

[John]

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?

 

[Jon Peltier]

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

 

[John]

Thanks for the thoughts

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
_______