Inserting a candlestick chart

Candlestick charts are used to show gains and losses in stock prices (or other value-based indices) and volumes over time.

1. Double-click the Candlestick Chart object in the Layouts palette of the Palette view.
   The Candlestick Chart Wizard opens.
2. In the All Data Sources tree, navigate to the table or query that will be run to obtain the layout object's query result set and click Next.
   The Select options for a candlestick chart page opens.
3. In the Trading interval drop-down list, select the trading interval over which the stock values are to be charted.
   Select an interval from the drop-down list of available choices that includes a second, minute, hour, day, week, month or year.
4. In the Date drop-down list, select the name of the data column in your query result set that contains the trading date.
5. In the Open drop-down list, select the name of the data column in your query result set that will contain the stock's open price on each date.
6. In the Close drop-down list, select the name of the data column in your query result set that will contain the stock's close price on each date.
7. Select the Show high price check box to display the high price for the stock.
8. In the High drop-down list, select the name of the data column in your query result set that will contain the stocks high price on each date.
9. Select the Show low price check box to display the low price for the stock.
10. In the Low drop-down list, select the name of the data column in your query result set that will contain the stock's low price on each date.
11. Select the Show volume of trading check box to display the volume of trading for each stock.
12. In the Volume drop-down list, select the name of the data column in your query result set that will contain the volume that the stock traded on each date.
13. Click Finish.
    The Candlestick Chart Wizard closes and the chart is displayed in the editor window.