Tables can be an orderly and clear way to summarize results in your subject report.
Click New Table on the top-left to add a new table to your report.
You can choose your table type in one of two ways:
- Click on an existing table and then click Table Type on the toolbar above.
- When you create a new table, click the Table Type dropdown.
Once you’ve opened the list of table types, you will see the following options. Click on a link to learn more about that specific table.
Header and Column Options
When you hover over the header in a table, a dropdown arrow will appear that allows you to edit settings for the header or column.
- Font: Determine the font face, font color, and font size of the header
- Cell Alignment: Choose whether the text in the header is left-justified, right-justified, or centered.
- Rename: This option is only available when editing the header. Change the header text.
- Font: Determine the font face, font color, and font size of the column.
- Cell Alignment: Choose whether the text in the column is left-justified, right-justified, or centered.
- Conditional Cell Formatting: Create conditions where the background color, font color, font size, and font bolding of the cells in your column can change!
Fonts and Table Styles
When you right-click on table and click Table Options, or you click on a table and then choose Table Options from the toolbar, you will have a Font option. Here you can change the font face, size, and color for your table.
Just below the font options, you’ll notice a series of premade table styles to choose from. Click on one of these to change the look of your columns and rows.
You can access Table Options by right-clicking on a table, or by clicking on the table and then the Table Options button in the toolbar above.
Some table options are exclusive to a type of table.
Determine the number of decimal places displayed for each number in your table.
Select Transpose to switch the rows and columns. For example, here is a Statistics Table without being transposed:
And here is the same table, transposed:
Choose a component to sort the table by. For example, if you choose to sort by the “Leadership” scoring category, higher Leadership values will be at the top of the table, in descending order.
Determine the maximum number of rows your table can have. Choose None to let all the data fit the table, or choose a number from 1-10.
When you choose None, your table will not automatically break into multiple pages to accommodate lots of data. If you’re worried about your data running over, please check out the Split Table Settings section, or read about Automatically Create Pages for Additional Rows below.
When you select Show/Hide Rows, you can determine what rows of your table to display or hide. When you select Show/Hide Columns, you can determine what columns of your table to display or hide. Items that are shown are indicated by checkmarks next to their names.
This setting is helpful if there’s certain data you don’t want to include. For example, if you want your Statistics Table to only display the mean, minimum, and maximum values, you can hide the Variance, Standard Deviation, and Total Responses and Respondents.
When you select Uniform Cells, the cells in your table become the same height and width as each other. This setting is helpful if the text inside the cells is about the same size, and do not contain any particularly long statements.
When you deselect Uniform Cells, the cell tries to fits as best it can around the length of the text inside. Note in the table below how the “Loyal to the Company” column elongates.
Expand to Height
When selected, Expand to Height fits the table to whatever space you’ve stretched it to.
If you deselect Expand to Height, the table will take up the minimum of the space it needs to get the information across.
If you’ve made changes to the rows or columns that are displayed, changed the font, or made any other customizable changes to your table, you can remove them by clicking Clear Properties. This option is not reversible!
Split Table Settings
Sometimes, you may collect hundreds or thousands of open-ended feedback from your participants. Or you may create a table with tons of data sources, expanding the number of rows it contains. If you have so much data it runs off the page, you can use Split Table Settings to shorten the table or split it into multiple pages.
If you want to split your table into multiple pages and not just shorten it, you first need to create multiple copies of the same table.
You can create multiples of the same table one of two ways:
- Copy the whole page.
- Click New Table on the toolbar and rebuild the copies from scratch.
Then navigate to Table Options and select Split Table Settings to get started.
You have two options for splitting a table: Split the table up into pages and Choose a start row.
Split the table up in pages
This setting is better if you want split tables to have a uniform number of rows on each version.
- Select Split table up into pages.
- Decide on the number of rows you want to display on each page of the table.
- Once you’ve determined Rows per Page, the Split Table Settings will now create separate pages for your table. Select from the dropdown which page you want to display on your table.
- When finished, click Save.
For example, you might have three pages of the same table. Under the Split Table Settings, you would assign them Page 1, Page 2, and Page 3, separately.
Choose a start row
This setting is better if you’re looking to start on a special row, or customize what data range appears in each copy of the table.
- Select Choose a start row.
- Determine your Start Row.
- Choose how many rows to display.
With this setting, you would arrange your table copies to pick up where the others left off. For example, if your first table shows rows 0 to 15, your next table would show 16 to whatever higher range you prefer.
Headers count as rows, but if two are next to each other, they count together. For example, in this screenshot, 6 rows display on the table in the background.
In this screenshot, headers are excluded because we start on 1 instead of 0, so the table shows exactly 5 rows, as specified.
Automatically Create Pages for Additional Rows
When you have too much data to fit into your table, you can make the table create additional pages automatically to accommodate this. This option serves as an alternative to Split Table Settings.
- Open Table Options.
- Click Automatically Create Pages for Additional Rows.
- Select Expand To Additional Pages.
- Fill out the maximum number of pages that can be created automatically. The maximum is 100.
Qtip: This setting does not mean that 100 pages will be created. It also does not mean that only 100 responses will be included. It means that if there were thousands of possible rows, they’d take up a maximum of 100 pages before they stopped generating.
- Select the Templates to Use when the page is generated.
Qtip: Check out the Templates section of the Reports Pages guide to learn more about templates.