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 high or maximum value. This value is the top 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 minimum value. This value is the base 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'll 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
Tuesday $24 $22 $17 $17
Wednesday $23 $17 $23 $15
Thursday $27 $23 $26 $22
Friday $29 $26 $28 $24

 

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

true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
3880118124802918266
true
Search Help Center
true
true
true
true
true
35
false
false