Versions Compared

Old Version 7

changes.mady.by.user Unknown User (rpr6ha)

Saved on

compared with

New Version 8

changes.mady.by.user Veronica Kuhn

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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.

 

Customization Options

Go to Common Options for Charts and Graphs  for options on how to customize the appearance of your chartLearn about options at Common Customization Options.