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.
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 |
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 |
Customize a candlestick chart
- On your computer, open a spreadsheet in Google Sheets.
- Double-click the chart you want to change.
- At the right, click Customize.
- Choose an option:
- Chart style: Change the background color and font.
- Chart & axis titles: Edit or format title text.
- Horizontal axis: Edit or format axis text, or reverse axis order.
- Vertical axis: Edit or format axis text, set min or max value, or log scale.
- Gridlines: Add and edit gridlines.