Scripting Charts

To Generate Chart Scripts:

1. Execute in the Query Window	2. Show Charts Icon	3. Set Category and Series	4. Set Chart Options

5. View Script Tab	6. Right Click Script Full to New Window	7. Generated Script in New Window	8. Click Charts Icon to View Re-created Charts

1. Launch the Query Analyzer and execute the query.

2. In the results grid, click on the icon 'Show Charts'.

3. Select a chart type and select Category and Series.

4. Click on the Chart Options icon.

5. In the chart options, make changes. The script is automatically updated for any changes that you make. Click on Scripts tab, you can preview or copy the chart script from this tab.

Alternate method to generate Chart Scripts:

6. Right-Click on any cell of the results grid. The menu which appears has two options, Script to Window and Script Full to New Window, for creating a script of the current chart.

7. Click on any one of the item and the chart script is generated together with the executed SQL. Script Full to New Window writes the script to a new query window.

8. Click Show Charts icon in the New Full Window to see it is identical to the previous window and chart.

You can save the scripts and share them with Business Analysts or Developers. They can then re-create the scripts and charts very quickly with the appropriate settings. If the script is run from live data, any changes in the data will be reflected when they execute the scripts you've given them. The chart settings will remain the same.