Candlestick chart

Candlestick charts are used to show an opening and closing value overlaid on a total variance, and they're often used to show stock value behavior. In this chart, items where the opening value is less than the closing value (a gain) are drawn as filled boxes, and items where the opening value is more than the closing value (a loss) are drawn as hollow boxes.

Create a candlestick chart

To create a candlestick chart, enter the following values into columns. Each row describes a single candlestick marker.

  • Column 0: Enter a label for the X-axis.
  • Column 1: Enter a number specifying the low/minimum value of this marker. This is the base of the candle's center line.
  • Column 2: Enter a number specifying the opening or initial value of this marker. This is one vertical border of the candle. If this value is less than the value in Column 3, the candle will be filled; otherwise, it will be hollow.
  • Column 3: Enter a number specifying the closing/final value of this marker. This is the second vertical border of the candle. If this value is less than the column 2 value, the candle will be hollow; otherwise ,it will be filled.
  • Column 4: Enter a number specifying the high/maximum value of this marker. This is the top of the candle's center line.

To create a candlestick chart from your data set, select Insert > Chart. In the charts dialog, click the Charts tab, then click Trend. Select the candlestick chart, and click Insert. Your chart will be inserted into your spreadsheet.

Learn how to customize your chart.