Excel and PowerPoint Table Layouts

Depending on the output you need, OfficeReports creates tables in either 'PowerPoint' or 'Excel' layout.

Reporting 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.

Analytics Layout

This is the more traditional way of lay-outing crosstabs: