Introduction
This post describes how to link tables and charts created in Displayr...
...to tables and charts created in PowerPoint...
...and update the PowerPoint tables and charts with revised data from the outputs in Displayr.
This approach can be used to link and update an existing PowerPoint report, or to populate specific tables and charts with data from tables created in Displayr.
Requirements
- A table and/or chart created in PowerPoint.
- A Displayr table and/or chart with Statistics (e.g., %, count) matching what is shown in PowerPoint.
- A Displayr table and/or chart with a matching layout to the chart used in PowerPoint.
- If the data layout doesn't match: in Displayr, select the table/chart and go to the object inspector > Inputs > Data Source and select Switch rows and columns.
Method - linking a Displayr table to a PowerPoint table
- Ensure that the Statistics and layout of the Displayr table match the content and layout of the table in PowerPoint.
- In Displayr, select the table and go to object inspector > Properties > GENERAL > GUID.
- Use your mouse to select the GUID by clicking and dragging to highlight it, and then right-clicking on it to select Copy.
OR
-
- In Displayr, select the table and go to Copy > Copy GUID.
- In PowerPoint, select the table you wish to link the Displayr table to.
- Right-click on the table select Edit Alt Text...
- Paste the GUID from Step 3 into the Alt Text field.
You are now ready to update the PowerPoint report with data from Displayr. See How to Update an Existing PowerPoint Document for full details.
Method - linking a Displayr table to a PowerPoint chart
- Ensure that the Statistics and layout of the Displayr table match the content and layout of the table in PowerPoint. To check the required layout, open your PowerPoint document, select the chart, right-click, and select Edit data.
- In Displayr, select the table and go to object inspector > Properties > GENERAL > GUID.
- Use your mouse to select the GUID by clicking and dragging to highlight it, and then right-clicking on it to select Copy.
OR
-
- In Displayr, select the table and go to Copy > Copy GUID.
- In PowerPoint, select the chart you wish to link the Displayr table to.
- Right-click on the chart and select Edit Alt Text...
- Paste the GUID from Step 3 into the Alt Text field.
You are now ready to update the PowerPoint report with data from Displayr. See How to Update an Existing PowerPoint Document for full details.
Method - linking a Displayr chart to a PPT chart
- Ensure that the Statistics and layout of the Displayr table match the content and layout of the table in PowerPoint. To check the required layout, open your PowerPoint document, select the chart, right-click, and select Edit data. To check the table layout in Displayr, select the chart and go to the object inspector > Inputs > Output > Table. To change the table back to the previous state Undo the previous action.
- In Displayr, select the chart and go to object inspector > Properties > GENERAL > GUID.
- Use your mouse to select the GUID by clicking and dragging to highlight it, and then right-clicking on it to select Copy.
OR
-
- In Displayr, select the table and go to Copy > Copy GUID.
- In PowerPoint, select the chart you wish to link the Displayr table to.
- Right-click on the chart border and select Edit Alt Text...
- Paste the GUID from Step 3 into the Alt Text field.
You are now ready to update the PowerPoint report with data from Displayr. See How to Update an Existing PowerPoint Document for full details.
See Also
How to Export a Document to PowerPoint
How to Export Editable PowerPoint Charts
How to Update an Existing PowerPoint Document
How to Upload a PowerPoint Chart Design Template to Displayr
How to Create and Apply a Chart Template in Displayr
How to Apply a PowerPoint Chart Style to a Chart in Displayr
Comments
0 comments
Article is closed for comments.