Definition
A candlestick chart is used to show an opening and closing value overlaid on top of a total variance. Candlestick charts are often used to show stock value behavior. In this chart, items where the opening value is less than the closing value (a gain) are drawn as filled boxes, and items where the opening value is more than the closing value (a loss) are drawn as hollow boxes. (see the doc of Google)
Data format
Five or more columns, where the first column defines X-axis values or group labels, and each multiple of four data columns after that defines a different series. In order to have more series, it is possible to add additional sets of 4 columns, with a similar structure to columns 1-4. Each such set represents another series of candlesticks. The total number of columns should be 4 times the number of series plus 1 (and any optional tooltip columns).
Column | Type | Description |
---|---|---|
0 | String (discrete) used as a group label, or number, date, datetime, or timeofday (continuous) | X axis |
1 | Number | low/minimum value of this marker |
2 | Number | opening/initial value of this marker. |
3 | Number | closing/final value of this marker |
4 | Number | high/maximum value of this marker |
5 | Number (Optional) | A tooltip or style column for the candlestick. |
Chart options
Each option is separated by a '|' or '!' (for Mediawiki).
Name | Default | Description |
---|---|---|
width |
100% | Chart width |
height |
Chart height | |
Others... |
You can use the configuration options of Google. See the doc |