My own stock chart with open/close same level?


J

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
 
Ad

Advertisements

J

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?
 
J

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
 
Ad

Advertisements

J

John

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
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top