The Standard function allows you to export your report to excel, including both tables and graphs.
This can be useful in cases where you want to change the colors on the graphs or if you want to use the graphs or tables in PowerPoint.
How to export a report to Excel
1. Create your report with all your specifications.
2. Go to the Export menu and click on the Standard button and a new window will open.
3. If you have more than one language in your report, choose the language the report should be created in. In the new window you can see that the report is generated. Click OK to continue.
Note: Depending on the reports size and the number of replies the export can take a while.
When the report is generated you will be presented with a window where you can choose to Download or to Save the report online. If you choose download you will be presented with a browser window, there you have to click Open.
Excel report
When the report has been exported and opened in Excel you will get the tables and graphs in a default setup. You can change this in Excel or you can copy your tables to i.e. Word or PowerPoint.
The first sheet is a introduction sheet. Here you can see the name of the project.
The second sheet is a Frequency sheet where you can see tables with number of replies and percentages. If you have added additional statistics settings, i.e. average values, standard deviation etc. these calculations will also be presented in the Frequency sheet.
The third sheet is a matrix sheet where you can see number of answers and percentages on matrix questions.
After the first sheets the report includes sheets with a graph per sheet. The different graphs will be named Fig. X... etc.
Note: When you have exported your report to Excel you will be able to change colors, graph types, page setup etc. These settings will only be changed in the specific Excel report.
Tip: If you need to create many reports of the same type, then perhaps it can be an advantage to create a report template with xml attachments.
Comments