UPCOMING WEBINAR: Build it once. Use it again: Create reusable charts with AI Register now >>

Articles in this section

Publishing to Excel, PowerPoint, Google Slides, and as a PDF

  • Updated
Follow

Preparing your report for export

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 right-clicking them and selecting 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 for 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 from other programs about when and how to draw things (e.g., if a line is 50% on one pixel and 50% on the other).
  • If you are exporting to Google Slides, there are additional differences, depending on your exporting settings. See Caveats and Limitations When Exporting From Displayr to Google Slides for more information.

Exporting to Excel

  1. Go to Share > Export Report > Excel.
  2. Select Export Selected or Export All. 
  3. Optionally, choose Advanced Options to control things like how to arrange the outputs in the file, table styling, and whether to create a table of contents.
  4. Click Export.

For more information on exporting to Excel, see: How to Export to Excel.

Exporting to PowerPoint

  1. If you wish to have a visualization appear in PowerPoint as an editable chart, select the chart and choose Appearance > PowerPoint Export > Format > Microsoft Chart from Properties 26UI_ObjectInspector.png.
  2. OPTIONAL: Press Set as default to make the change to all visualizations in the document that have not been explicitly set. Click Reset to revert to the default settings. See the image below.
  3. Go to Share > Export Report > PowerPoint.
  4. Select Export Selected or Export All. 
  5. Click Export.

For more information on exporting to PowerPoint, start here: How to Export a Document to PowerPoint.

Please note that when exporting tables to PowerPoint, it controls the wrapping of column text in tables in the exported file. This means there are cases where what you see in Displayr may not completely match what you see in the export.

Export to Google Slides

  1. Go to Share > Export Report > Google Slides.
  2. Select Export All or Export Selected.
  3. If you have not already connected your Displayr account to Google, click Connect Google account and follow the prompts.
  4. Click Export.

See How to Export a Document to Google Slides for more information about exporting to Google Slides.

Export to PDF

  1. Press Share > Export Report > PDF.
  2. Select Export All or Export Selected.
  3. Press Export.

See How to Export to PDF for more information.

Export from View Mode

Instead of exporting many ad hoc pages, you can publish the document as a web page (dashboard) and leave the exporting to your client or viewer. The same Excel, PowerPoint, and PDF exporting functionality is available from dashboards in View Mode as well.

Next

Report Automation

Related articles