The result from a single StoryTeller chart and table can be exported into an Excel table in a similar way as the result of a Respondent table can be exported to Excel.When then new function is turned on an “export” button appears in top right corner of the chart/table when the user hovers over the object as shown in the image below.
Here we see the export button for exporting the result of chart or a table to Excel.
Note 1: the result is always exported as a table, you don’t get a native Excel chart when exporting a chart.
Note 2: The table layout will be the same as online when exporting a table. When exporting a chart a neutral layout is used (the one shown in the image above).
Note 3: the values in the chart are formatted as “numbers” as long as all value cells in the table can be formatted as numbers. If a cell cannot be formatted as a number, which can be the case when for example a cell shows both the actual value and a benchmark value, the values cells in the table will be formatted as text.
The new Excel export is supported in charts, tables and in dynamic images. It is an object level setting so the ability to make these exports is defined per object, the option is off by default (it is an object level setting as in most of the projects it will not be sufficient to use it in all reports and especially not in infographic inspired slides where multiple objects might be positioned on top of each other). The control for turning the export option on and off is located in the “Settings” tab in the “Other” pane las shown in the image below.Here we see the control for turning the new Excel export option on and off.
The option is also available in the bulk update process of charts which makes it easy to turn the export function on/off for all charts (or some of the charts) in a project. Here we see the same setting in the bulk edit screen.