Creating a Candle Chart
A candle chart displays four different measures, “low,” “high,” “opening,” and “closing,” and is most often used to plot trading information. A candle chart is functionally similar to a stock chart.
To create a candle chart that displays the averaged high, low, opening, and closing prices by quarter, follow the steps below:
1. Create a new report, and add a blank chart element. Click the chart to open the Chart Editor.
2. In the Data Source panel, expand the 'Stock History' node, and expand the 'Stock Prices' query.

3. Drag the 'Date' field from the 'Stock Prices' query to the 'X' region of the Binding panel.
4. Press the 'Edit Dimension' button next to the 'Date' field, and choose 'Quarter' from the 'Level' menu. Then press the green 'Apply' button.

5. Drag the 'High' field of the 'Stock Prices' query to the 'Y' region of the Binding panel.
6. Press the 'Select Chart Style' button in the Binding panel, and select the 'Candle' style. Press the green 'Apply' button.

Note that the Binding panel now provides binding regions for 'High', 'Close', 'Open', and 'Low'.

7. Drag the 'Close/Last', 'Open', and 'Low' measures from the 'Stock Prices' data block to the appropriate regions of the Binding panel, as shown below.

8. Press the 'Edit Measure' button next to the 'High' field, and choose 'Average' from the 'Aggregate' menu. Then press the green 'Apply' button.

9. Repeat the above step to set the aggregate to 'Average' for the other measures: 'Close/Last', 'Open', and 'Low'.
10. Preview the chart.

11. To observe the structure of the chart more closely, set a condition on the chart to limit the date range (e.g., limit to the second half of 2002), enlarge the chart element, and/or change the axis limits.

Note that for each quarter, the values of each of the measures (High, Low, Close/Last, Open) have been independently averaged. The “high” and “low” measures are represented by the extremes of the candle “wick,” and the “open” and “close” measures are represented by the extremes of the candle “body.” Candles for which the “open” measure exceeds the value of the “close” measure are shown filled. Candles for which the “close” measure exceeds the value of the “open” measure are shown unfilled.
See Also
Binding a Chart to Geographical Data (Map), for details on binding geographical data.
Setting a Chart Style for an Individual Dataset, to set distinct styles for individual datasets.
| << Creating a Pie Chart | © 1996-2013 InetSoft Technology Corporation (v11.5) | Creating a Table-Chart Hybrid >> |