Learn how to export your analysis tables and charts directly to Excel and PowerPoint.
Harmoni has been designed as a holistic data delivery platform. From loading the source data, designing the project to enable smart, easy analysis that is easily added to stories and dashboards, so your data can stay in one place through the whole process. The best way to share results and insights generated in Harmoni is in the Harmoni environment.
You can, however, also export your charts and tables to PowerPoint and Excel from Harmoni. The intention of these export functions is to provide slides and tables that are close to the Harmoni view being exported, but they may not be identical. Charts are exported to PowerPoint as editable objects so you can get them just the way you need them once they’re exported.
In this article
1. Direct Export
You can export your analysis or dashboard directly to Excel or PowerPoint. Click the Excel or PowerPoint icons in the top right corner.
- The information included in the i-bar, for example, the reference, suppress zero, sample warnings etc., is included in the export.
- The exportable chart types are exported to PowerPoint in an editable form.
- When exporting a line chart with a time slider, Harmoni exports the number of time periods you see in the chart. To export all time periods, drag the slider to display all time periods before exporting.
- When exporting to PowerPoint you have the option to customize your story using themes.
Learn more about PowerPoint Templates.
Exporting a view to Excel or PowerPoint does not save the view in Harmoni.
Export an Analysis Table to Excel
- Create an analysis
- Click Export to Excel
- Open the file from your downloads folder
Note: If pagination is turned on for exports, you will see a different message. It may take slightly longer than a non-paginated export. Pagination is designed to accommodate very large exports and is not turned on for most sites.
Export a Chart to PowerPoint
- Visualize an analysis
- Click Export to PowerPoint
- Open the file from your downloads folder
When exporting a chart from Harmoni, the link between the data and data labels is disconnected. Learn more about Export Formats.
Where to from here?
Learn more about Harmoni: