Publishing to Excel, PowerPoint, and as a PDF

Preparing your report for publishing

In most regards, Displayr is set up so that What You See Is What You Get (WYSIWYG) when you export. However:

• Objects in Displayr - pages, charts, text boxes, etc - can be hidden from export by selecting them and pressing Hide.
• Sometimes there will be very small differences between how things appear on the screen and how they are exported. These differences will typically be very, very, small (e.g., a pixel). There are a couple of causes of this. First, your browser will automatically do some things differently to programs you export into (e.g., different rules about when to wrap text). Second, browsers use slightly different rules to other programs about when and how to draw things (e..g, if a line is 50% on one pixel and 50% on the other).

Exporting to Excel

To export to Excel:

1. Press Publish > Export Pages > Excel
2. Optionally, choose Advanced Options to control things like how many worksheets to export on, table styling, and whether to create a table of contents.
3. Press Export.

Exporting to PowerPoint

To export to PowerPoint:

1. If you wish to have a visualization appear in PowerPoint as an editable chart, select the chart and choose Properties > POWERPOINT EXPORT> Format > Microsoft Chart. Press Set as default to make the change to all visualizations in the document which have not been explicitly set. Click Reset to revert to the default settings. See the image below.
2. Press Publish > Export Pages > PowerPoint
3. Press Export.

Export to PDF

To export to as an Adobe PDF file:

1. Press Publish > Export Pages > PDF
2. Press Export.