Candlestick Charts

[Rich Reed]

Sorry if this a repeat from another post, but I am new to the newsgroup.

I am looking for an excel spreadsheet for Japanese Candlestick Charting.
Any help is appreciated.

Rich in Maine

 

[Jon Peltier]

Rich -

Make a line chart with your two series of data. Double click on of the
series, choose the Options tab, and check the box for Up-Down Bars.
Where the first series' value is higher than the second's, the bars are
one color, when they are switched, the color changes. You can format the
bars as if they were columns in a regular column chart.

If you mean a stock candlestick chart, which shows a candlestick for
Open and Close and lines extending beyond these for High and Low, check
out the Open-High-Low-Close option under Stock chart types.

- Jon