Excel and PowerPoint Table Layouts
Depending on the output you need, OfficeReports creates tables in either 'PowerPoint' or 'Excel' layout.
The Reporting Layout creates tables which are perfect for populating charts in PowerPoint by doing the following:
- Table statistics like total, mean, standard deviation etc. are separated from the values for the categories (answer options).
- Only the percentage or the count is reported, not both at the same time.
- Significance is shown using background colors
As you can see in the tables below, the data range we need for a chart is much more easily selectable in the 'reporting' table than in the 'analytics' table further below.
This is the more traditional way of lay-outing crosstabs: