User guide

Using Excel with Datastream Advance for Office
Page 26 of 38
5 USING THE REQUEST MANAGER
You can create and embed any number and type of data and chart requests in a single worksheet. For example, a
worksheet could contain an embedded time series data request, a static data request, a company accounts data
request, and an embedded Datastream chart all for the same series and time period. If you want to change the
time period for one request, you would need to search through the worksheet to find the required request and
use the right-mouse click Edit option. The Request Management facility, however, enables you to quickly
pinpoint the required request and edit, refresh, autorefresh, or delete its details.
The Request Manager dialog, displayed by selecting Request Management>Request Manager from the
Datastream menu, displays details of all embedded requests within an Excel workbook. To edit, refresh, or
delete a request, click on the request‟s detail line and click the appropriate button.
EDITING AN EMBEDDED CHART
The charts embedded in Excel can be edited back in Datastream. All aspects of the chart can be changed. Here
the series, time period and display can be changed. Line Styles, Text Styles and Fill Styles are a part of display
properties of the chart. They can be customised and saved as schemes. When you create a chart next time, you
can directly apply the saved scheme to the chart.
To edit an embedded chart in Datastream:
1. Open the worksheet with the chart you want to edit.
2. Right click on the chart and select Edit Chart option. The chart is displayed in Datastream.