User guide

Using Excel with Datastream Advance for Office
Page 28 of 38
4. Right click on the chart and click Update Chart to transfer the updated chart back to Excel in the same
place.
CHANGING THE PROPERTIES OF A CHART USING VBA
Experienced users can use Excel‟s VBA Design Mode to access and edit the properties of embedded charts the
Properties dialog. On the ChartControl Properties dialog you can change the request description, request
string, autorefresh selection and chart dimensions.
To change the properties of a chart using VBA:
1. Right-click on the Excel toolbar and select Visual Basic.
2. Click the Visual Basic Design Mode button on the Visual Basic toolbar.
3. Click on the chart that you want to edit.
4. Right-click on the chart to display the Excel menu and select the DatastreamChart>Properties option.
The ChartControl Properties dialog is displayed:
5. Change the properties as required, click Apply to confirm your changes and click OK to exit the
Properties dialog.
Refresh the chart for the new properties to take effect.