Inserting a stock chart

Stock charts are used to show fluctuations in stock prices, or other value-based indices, and volumes over time.

About this task

To insert a stock chart:

Procedure

  1. Double-click the Stock Chart object in the Layouts palette of the Palette view.
    The Stock 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 stock 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, specify the name of the data column in your query result set that contains the trading date.
  5. In the High drop-down list, specify the name of the data column in your query result set that will contain the stocks high price on each date.
  6. In the Low drop-down list, specify the name of the data column in your query result set that will contain the stock's low price on each date.
  7. Select the Show open price check box to display the open price for the stock.
  8. 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.
  9. Select the Show close price check box to display the close price for the stock.
  10. 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.
  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 Stock Chart Wizard closes and the chart is displayed in the editor window.