Next
When you select Microsoft Word in the Export Tables dialog box, a number of additional options become available. Note that to use this option, you need to have Microsoft Office 2007 or later installed on your desktop machine.
Include. Use this option to specify whether the export should create tables only, charts only, or both tables and charts, and whether the chart or the table should be shown first. Note that the charts are created using Microsoft Excel, so you need to have both Word and Excel installed to be able to use the chart options.For details of the way in which you can display data in charts, see Displaying Results in Charts.
Default chart type. If you have chosen to export charts, select a chart type from the drop-down list. If you want to use a custom chart that you have created in Excel, type in the name of the custom chart.
Note: The chart type you select is used only if you have not specified a chart type for a table using the Table Properties dialog box.
Hide Word during export. Select this option to hide Word during the export. This makes the export run faster. However, this option is not recommended if you are using Word 2000, because it can lead to the export failing.
Launch Word after export. Select if you want IBM® SPSS® Data Collection Survey Reporter to automatically launch Word and open the file that contains the exported table(s).
Note: You may need to set an access security setting in Word before you can run the export. If this applies to your machine, Survey Reporter will display a message telling you this. For step-by-step instructions on setting the security setting, see Enabling security access for Microsoft Excel, Word, and PowerPoint exports.
Apply Word template. Enter the name and location of a Word template to use, or choose the Browse button to browse to the folder containing the template. Leave this text box blank if you want to use the default template. See the topic Formatting the Output in Microsoft Word for more information.
Save to file. Check this box and enter a name and location for the output file, or choose the Browse button to browse to the folder where you want to save it. If you do not specify a save location, and the Launch after export option is also not selected, you are prompted to either launch the associated application or select a save location.
Choose the Advanced button to view or edit the Advanced Word Export Properties dialog box.
Display Properties:
Variable. Choose whether to use variable names or the more friendly descriptions for the variable texts in the tables.
Category. Choose whether to use category names or the more friendly descriptions for the row and column headings in the tables.
Table of Contents. Select this option if you want the export to create a table of contents. By default, the table of contents is generated from the text in the left header position. This works best when you display the table description (and nothing else) in the left header position. See the topic Changing the Headers and Footers Used in the Table of Contents for more information.
Borders. Select this option if you want the tables to have borders.
Headers and footers. Select this option if you want to export the headers and footers that have been defined for the table. When this option is selected, the headers and footers are positioned on the page above and below the table to which they relate. Note that they are not positioned using the Word header and footer feature.
Variable and category images. Select this option if you want to export images associated with table rows and columns. These may be images that were specified when the data was created using IBM® SPSS® Data Collection Interviewer Server, or they may be images that were added to your tables using IBM® SPSS® Data Collection Base Professional Tables Option.
Chart Properties:
Chart series. Choose whether you want the table rows or columns to form the chart series. If you select the Chart category elements or Chart special elements box, ensure that the orientation of the categories or special items (in rows or columns) corresponds to the setting entered here. For example, to create a chart for a mean that appears on the top of a table, choose as columns.
Chart category elements. You can optionally create charts for individual categories, for individual variables, or for all variables on the table. Select:
• Per element to create a separate chart for each category in the variable(s).
• Per variable to create a chart for each variable(s).
• Per table creates a single chart for all variables on the table.
Chart special elements. You can optionally create charts for statistical items (such as the mean, minimum value, standard deviation, etc.). Select:
• Per element to create a separate chart for each statistical item in each variable.
• Per variable to create a chart for all statistical items in each variable.
• Per table creates a single chart for all statistical items in all variables on the table.
Base chart on. If you want to base charts on a cell item other than the default, select the cell item from the drop-down list. The cell item must be included in the table.
Display series base. Select this option to display the base for the chart series in the legend for the chart.
Display base for last series category. Check this box to display the base for the last data point in the chart legend. This option is applicable only when charting special items. If the count cell item is present, this is used. If not, the unweighted count cell item is used.
Display column statistics results. Displays the column IDs for a column proportions or column means test next to the category descriptions, and adds the column proportions test results to the chart above the relevant columns.
Chart percentages using scale of 0 to 100%. Check this box if you want percentages to be charted on a scale of 0 to 100%. If this option is not selected, the scale is based on the biggest value in the chart.
Page Properties:
Repeat heading rows. This option affects tables that are too long to fit on one page and need to be split across two or more pages. Select this option if you want the table column headings to be repeated on every page. Deselect this option if you want the column headings to appear on the first page only.
Insert page break after each table. Select this option if you want a page break to be inserted between the exported tables. Note that this option does not insert a page break between tables and charts.
Click to see a
picture of the Export Tables dialog box with Microsoft Word selected
Click to close the picture