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 3Column 4Column 5
Data Typeplain text, number, date, date time, or time of daynumbernumbernumbernumber
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 label for this column will appear in the legend – other column labels will not appear

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.
Requiredxxxxx

 

Customization Options

Learn about options at Common Customization Options

  • No labels