Exporting to PowerPoint
All parts of Working With PowerPoint (Video)
Q can automatically export charts, tables and text to PowerPoint and update the PowerPoint presentation to reflect updates of data in Q.
The underlying programming for how this is done is changing with the introduction of Q version 5.11. You can check the version of Q you have installed by going to the Help menu and selecting About. Contact Support for further information.
- 1 Exporting to PowerPoint Q version 5.11 or later
- 2 Exporting to PowerPoint - Q up until and including version 5.10
- 2.1 Charts
- 2.2 Tables
- 2.3 Slide Layout
- 2.4 Footers
- 2.5 See also
Exporting to PowerPoint Q version 5.11 or later
To export a selected output from Q to PowerPoint you can either click on the PowerPoint export icon , or by right-clicking on the Q output > | Export to Office > Export to PowerPoint.
A Table Options dialog box appears, where you can select the desired Format and Chart type. Outputs can be exported as Images, or editable Tables or Charts.
Export editable charts to PowerPoint
In the Table options menu, set the Format to To PowerPoint as Excel Chart and select the desired chart type from the Chart menu.
Update an existing PowerPoint document
Charts, tables and images exported from Q to a PowerPoint document are linked back to Q and can be updated. Note: this feature is not available when exporting format is set to To PowerPoint as Microsoft Graph.
This feature is particularly useful for updating reports for tracking studies. However, it has numerous other uses such as updating a specific output or report after applying a different filter (e.g. country), adding a cross-break, merging answer codes or adding a net, to name just a few.
Select the file you wish to update. Q will create a new file, the content of which will be updated to reflect any changes done in Q. Q will save the file in the same folder alongside the original file, adding a consecutive number to the name (e.g. Export(1).pptx).
Updating is based on GUIDs
Every object that can be updated from Q has a GUID (Globally Unique Identifier code) assinged to it. To see the GUID right-click on the output and select Show GUID for this Item.
GUIDs are recorded in the PowerPoint Alt Text field
In order for Q to update an object in PowerPoint, it is necessary to record the GUID in the Alt Text field in PowerPoint. This field is accessed in PowerPoint by right-clicking on the object (e.g., a chart), and selecting Edit Alt Text.....
Connecting PowerPoint charts to Q
To connect a chart created in PowerPoint to an output created in Q select the output in Q > right click > Show GUID for this Item. You can select the GUID by using your mouse and clicking and dragging over it. It can be copied by right-clicking and selecting Copy. In PowerPoint right-click on the object > Edit Alt Text.... > CTRL+V (paste). The object in PowerPoint is now connected with Q and can be updated.
In order for PowerPoints outputs such as charts to update correctly, it's important to ensure that the layout of the data tables in Displayr and in the PowerPoint chart match – that is that the rows and columns of tables are positioned in the same way. To check the required layout, open your PowerPoint document > select the chart > right-click > Edit data. If the layout of the table doesn't match go back to Q, select the table, right-click on either row or column heading and select Swap rows and columns.
Exporting to PowerPoint - Q up until and including version 5.10
Q can either create standard PowerPoint charts at the time of export, or, export its own internal Charts.
|PowerPoint Charts||Q Charts|
|Data can be edited and viewed||Can display significance tests|
|More extensive formatting options||Developed specifically for market research|
All of the standard Microsoft Office chart types can be exported and updated using Q, where 'standard' refers to the chart types that are selectable within PowerPoint, Excel and Word's Chart Type menus.
PowerPoint Chart Templates
Export Chart Defaults
Office Chart Types and Office Chart Templates can be set as defaults for particular combinations of data using Edit > User Options > Export Chart Defaults.
Q's Charts have been specifically designed for market research. In particular, they can display the results of tests of statistical significance.
Default fonts, font sizes, font styles chart colors can be set at Edit > Project Options > Customize > Charts.
Image of Table
When exporting To PowerPoint as Image of Table, the general appearance of the table is controlled via Table Styles.
When exporting To PowerPoint as PowerPoint Table, the general appearance of the table is controlled via settings in PowerPoint. The default table style comes from the Theme of the slideshow. You can change this default by right-clicking on your desired table style in the Table Style gallery of the DESIGN tab of the ribbon (you will need to manually change the first table).
The major aspects of the layout of a slide are determined by the settings within PowerPoint files, which are, in turn, controlled by PowerPoint templates and PowerPoint's Master Slide settings.
PowerPoint Export Layout
Additional control over the appearance of exports in PowerPoint is available within Q via the PowerPoint Export Layout settings.
Shrink tables to fit one slide
By default, large tables are shrunk to fit into the available space. This can be turned off by selecting User Options > Display/Printing and de-selecting Shrink tables to fit in one slide (when exporting to PowerPoint) or in page margins (when exporting to Word).
Footers can be extensively customized. See Footers.