Blog of Calc LLC

Candlestick charts are commonly used to show stock prices. In this tutorial we will create a candlestick chart like this: Suppose the stock price data is like below. Remember the first column has to be text. If this not text, format it as text. The stock price data has to be in the order of Low-Open-Close-High, which is different from Excel. If your data is not in this order, rearrange them now.  1. Click Insert > Charts. Ignore the recommended chart types. Change the chart type to Candlestick chart. 2. Now we get a candlestick chart. It is not very pretty though. 3. Right click the chart. Under Axis, choose Vertical axis.  4. Set the Min to 5. 5. Now we have a pretty candlestick chart. The blue candles are the days when close prices are higher than open prices. The white candles are the days when close prices are lower than open prices.

Suppose we have stock price of a stock like below. Note the stock prices have to be in the order of Open-High-Low-Close.  1. Select the data, then click Insert > Charts > Other Charts > Stock . We choose the Open-High-Low-Close one. 2. Now you see the chart  3. The legend of "open", "high", "low" and "close" is not really helpful. I would like to delete the legend. Right-click the legend then Delete . 4. Now you get a clean candlestick stock chart. Note: You can also add stock trade volume into a candlestick chart. However, the volume are plotted on the same display area as stock price, it does not look pretty in my opinion.