# Category:Rule Online Library

The Rule Online Library contains a set of Rules that can be applied to tables and charts directly from Q. These have been written to accomplish some common table and chart manipulations that users wish to apply in Q. This includes changing labels, changing the colors of cells, adding new rows and columns, and more.

## Applying Rules To Tables and Charts

This feature is available in Q version Q 4.8 and higher. To apply one of these rules to a table or chart:

- Select the relevant Tables or Charts in your Report.
- Select
**Automate > Online Library**. - Select the rule from the list. Rules appear with the icon: .
- Make any selections (e.g. colors, statistics, etc) that are appropriate to the rule.
- Click
**OK**.

Any options that are available for a rule (for example, selecting colors and statistics) can be changed by selecting the Rules tab tab below your table, selecting the rule from the list, and then clicking **Edit Rule**.

## Pages in category ‘Rule Online Library’

The following 69 pages are in this category, out of 69 total.

### C

- Computations - Add Naive Total For Each Column
- Computations - Add Naive Total For Each Row
- Computations - Adding Average Columns to Tables Containing Spans
- Computations - Adding Average Rows to Tables Containing Spans
- Computations - Adding Rows to Display the Effective Column n
- Computations - The Average of Each Column
- Computations - The Average of Each Row
- Computations - The Difference Between a Pair of Columns
- Computations - The Difference Between a Pair of Rows
- Computations - The Weighted Average of Each Column

### M

- Modifying Cell Content - Add Symbols to Significant Cells
- Modifying Cell Content - Adding Text to Cells with Large Numbers
- Modifying Cell Content - Blanking Cells With Small Sample Sizes
- Modifying Cell Content - Blanking Cells With Small Values
- Modifying Cell Content - Changing the Color of Cells With Small Sample Sizes
- Modifying Cell Content - Changing the Missing Data (NaN) Symbol
- Modifying Cell Content - Color - Color Selected Rows or Columns
- Modifying Cell Content - Color - Shade Rows or Columns
- Modifying Cell Content - Color - Shade Spans
- Modifying Cell Content - Highlighting Cells Above and Below NET
- Modifying Cell Content - Remove Decimals Without Rounding
- Modifying Cell Content - Replace Small Values With Text
- Modifying Cell Content - Round Data
- Modifying Cell Content - Shading NET Rows and Columns
- Modifying Footers - Adding a Column Header Footnote Indicating Small Sample Sizes
- Modifying Footers - Adding a Footer Showing the Smallest Sample Size on the Table
- Modifying Footers - Adding a Footnote to Cells with Small Sample Sizes
- Modifying Footers - Adding Column Base Sizes
- Modifying Footers - Description of Selected Data (e.g., Question name, skips, filtering)
- Modifying Footers - Display SPSS Custom Attribute
- Modifying Footers - Display Which Columns Are Being Compared
- Modifying Headers - Abbreviate Month Labels
- Modifying Headers - Adding Column Names to the Column Labels
- Modifying Headers - Adding Sample Size to the Column Labels
- Modifying Headers - Automatically Removing NET From a Table
- Modifying Headers - Automatically Removing The NET Column
- Modifying Headers - Automatically Removing The NET Row
- Modifying Headers - Automatically Rename Column Labels
- Modifying Headers - Automatically Rename Row Labels
- Modifying Tables or Plots - Ignore Missing Values In Column n In Statistics Below
- Modifying Tables or Plots - Show Maximum Column n In Statistics Below
- Modifying Tables or Plots - Showing Average Rank
- Modifying the Whole Table or Plot - Always Show Sample Size
- Modifying the Whole Table or Plot - Avoid Showing Outputs With Small Sample Sizes
- Modifying the Whole Table or Plot - Creating Rolling Averages
- Modifying the Whole Table or Plot - Hide Empty Rows and Columns
- Modifying the Whole Table or Plot - Hide Rows and Columns with Small Sample Sizes
- Modifying the Whole Table or Plot - Show Each Statistic in a Separate Column
- Modifying the Whole Table or Plot - Show Statistics Above
- Modifying the Whole Table or Plot - Showing A Range Of Rows
- Modifying the Whole Table or Plot - Showing Only the Top k and Specified Rows
- Modifying the Whole Table or Plot - Showing Only the Top k Rows (e.g., top 5 rows)
- Modifying the Whole Table or Plot - Unnest a Nested Banner on a Table

### S

- Significance Testing - Color Comparisons with a Specific Column
- Significance Testing - Color Significant Cells
- Significance Testing - Compute Column Comparisons on Grids with Lots of Missing Data
- Significance Testing - Independent Samples Column Means and Proportions Tests
- Significance Testing - Row Comparisons
- Significance Testing - Row Comparisons Using Column %
- Significance Testing - Show Column Comparisons to the Right of Values
- Sorting and Reordering - Change the Order of Statistics
- Sorting and Reordering - Making One Column Appear After Another
- Sorting and Reordering - Making One Row Appear After Another
- Sorting and Reordering - Move the NET Row to the Top
- Sorting and Reordering - Sort Rows (Automatically Updates when Data Changes)