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

Try this approach instead:

http://peltiertech.com/Excel/ChartsH...artTricks.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"John" wrote in message
...
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?

"Jon Peltier" wrote:

Try this approach instead:

http://peltiertech.com/Excel/ChartsH...artTricks.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"John" wrote in message
...
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

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
_______


"John" wrote in message
...
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" wrote:

Try this approach instead:

http://peltiertech.com/Excel/ChartsH...artTricks.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"John" wrote in message
...
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

Thanks for the thoughts

"Jon Peltier" wrote:

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
_______


"John" wrote in message
...
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" wrote:

Try this approach instead:

http://peltiertech.com/Excel/ChartsH...artTricks.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"John" wrote in message
...
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