Candlestick charts

Use a candlestick chart to show the low, high, opening, and closing values of a security for a specific period. For example, get the fluctuation in stock prices each day.

You can also use a candlestick chart to track scientific data, like rainfall or temperatures.

Learn how to add & edit a chart.

Candlestick chart

How to format your data

  • First column: Enter a label for the X axis.
  • Second column: Enter a number for the minimum value. This value is the base of the candle’s center line.
  • Third column: Enter a number for the opening or initial value. This value is one vertical border of the candle.
  • Fourth column: Enter a number for the closing or final value. This value is the second vertical border of the candle.
  • Fifth column: Enter a number for the high or maximum value. This value is the top of the candle’s center line.
  • Rows: Each row represents a single candlestick marker.

Note: If the value of the third column is less than the value of the fourth column, the candle will be filled. Otherwise, it will be hollow.

Examples

Monthly stock price
Month High Open Close Low
January $70 $20 $50 $15
February $66 $50 $45 $25
March $80 $45 $62 $30
April $95 $62 $85 $50
May $90 $85 $70 $60

 

Candlestick chart showing monthly stock prices

Make a copy

Weekly stock price
Day High Open Close Low
Monday $25 $23 $22 $21
Tueday $24 $22 $17 $17
Wednesday $23 $17 $23 $15
Thursday $27 $23 $26 $22
Friday $24 $26 $28 $29

 

Candlestick chart showing weekly stock prices

Make a copy

Customize a candlestick chart

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Double-click the chart you want to change.
  3. At the right, click Customize.
  4. Choose an option:

Related articles

Was this article helpful?
How can we improve it?