Harmoni has been designed as a data delivery platform so your data can stay in one place through the process. The best way to share results and insights generated in Harmoni is through Harmoni stories and dashboards.
You can also export your tables and charts 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 not 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
- Export Stories
- Export a view from a story
- PowerPoint export and template
- Excel export
- Invalid views
- Rounding on export
1. Export stories
There are three options to export entire stories to PPT or Excel.
1. From the three-dot menu on the Story tile, select Export to XLS or Export to PPT.
2. When you are in the Story preview pane, click on the XLS or PPT icons in the top right corner.
3. When you are in the Story View preview pane (after clicking on a story view), click on the XLS or PPT icons in the top right corner and select Export story from the drop down menu.
2. Export a view from a story
There are two options to export story views to PPT or Excel.
1. When you are in the Story preview pane, click the three-dot menu on the Story view tile and select Export to XLS or Export to PPT.
2. When you are in the Story view preview pane, click on the XLS or PPT icons in the top right corner and select Export view from the drop-down menu. Note, you can also use the three-dot menu on the story view tile in this pane.
3. PowerPoint export and template
Harmoni chart types exportable to PowerPoint, export in an editable format so you can get them just the way you need them once they’re exported.
When exporting to PowerPoint you have the option to customize your story using a PowerPoint template. A two page PowerPoint template, with a heading page and a content page, can be loaded onto a site by emailing email@example.com.
The first page of the PowerPoint template is the title page. This always appears as the first page of the PowerPoint file created when exporting from Harmoni.
The second page of the PowerPoint template is the content page. This is used as the template page for each view being exported from Harmoni.
Top, bottom, left and right margins can be set to ensure that the content exported from Harmoni goes into the appropriate place.
Table headings and single number display prefixes and suffixes use the font family set in the PowerPoint template.
The color of the graph axes and legends use a color that contrasts with the color set in the Background Styles, i.e. for dark-colored legends, choose a light color background style, and vice versa.
When exporting a single view, the PowerPoint file will have 2 pages – the title page and one content page containing the view content.
When exporting a full story with x pages, the PowerPoint file will have x+1 pages – the title page and a content page for each view.
4. Excel export
When exporting a story or a story view to excel, the tab names in excel automatically display the header name of the analysis.
Excel limits the tab names to 30 characters only to avoid long names.
5. Invalid Views
Occasionally you may notice a story view becomes invalid. This usually happens because the axes used to create the analysis (down, across, filter, etc.) are missing as a result of being deleted from the project or because these are not available when using Global filters. When a global filter is active, views will be filtered to only show applicable data to that filter.
When exporting to PowerPoint an invalid view will create a blank slide.
6. Rounding on export
Two rounding options are available in Harmoni. The default option is Bankers Rounding but this can be changed to School Rounding.
Bankers Rounding is an algorithm for rounding quantities to integers (whole numbers), in which numbers that are equidistant from the two nearest integers are rounded to the nearest even integer. We round 0.5 to the nearest even digit.
In School Rounding, the midpoint values (0.5) are rounded to the next number away from zero. This is the most widely known form of rounding. Learn more about rounding.
Whichever form of rounding is in place, the following rules apply on export:
- When exporting to Excel, we export numbers with the same number of decimal points as shown in Harmoni.
- When exporting to PowerPoint graphs, we plot the full number but display the rounded number.
- For example, in a graph, we plot 2.61 and 2.65, so the 2.61 appears lower, but they both show 2.6.
- When exporting to PowerPoint tables, we export numbers with the same number of decimal points as shown in Harmoni.
Where to from here?
Share with your team! Learn more about sharing stories within Infotools Harmoni.