Spreadsheet Format
Each row represents a candlestick on the chart. Learn more about using spreadsheets with Visuals at Use Spreadsheet Data.
Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | |
---|---|---|---|---|---|
Data Type | plain text, number, date, date time, or time of day | number | number | number | number |
Contents | The label on the x-axis. X-axes can be categorical (plain text) or continuous (number, date, date time, or time of day). | The minimum value for the candle. This marks the beginning of the candle's "tail" on the y-axis. Note:
| The opening value for the candle. This marks the beginning of the candle's body on the y-axis. | The closing value for the candle. This marks the end of the candle's body on the y-axis. | The maximum value for the candle. This marks the top of the candle's "wick" on the y-axis. |
Required | x | x | x | x | x |
Customization Options
Learn about options at Common Customization Options.