By pressing the button you will get a number of extra options to customize the test. By comparing columns pairwise it is possible to use colors instead of the significance characters.
Compare 2 by 2 - version A
Compares AB, CD, EF … and shows differences in the A, C and E …
Compare 2 by 2 - version B
Compares BA, DC, FE … and shows differences in the B, D and F …
Compare all columns to first column
Compares BA, CA, DA … and shows differences in the B, C and D …
Compare to next column
Compares AB, BC, CD … and shows differences in the A, B and C …
Compare to previous column
Compares BA, CB, DC … and shows differences in the B, C and D…
Customize the test settings.
The font color used, can be defined in LayoutàGeneral Layout DefinitionsàDefaultsàSignificance Colors
And here the same example using background colors:
The background color used, can be defined in LayoutàGeneral Layout DefinitionsàDefaultsàSignificance Colors.
This feature can be very powerful together with OfficeReport Infographics, which, based on the background colors in Excel can express significance in tables, charts and shapes in PowerPoint as icons that can be fully customized to the specific need.
By unchecking to compare pairwise, you can fill out exactly which columns to test in the bottom of the window. Like that you can e.g. test the different combinations of the first 4 columns of the table and the next three as well: “ABCD;EFG”.
Per default Significance Characters in cells in tables as in column/rows in charts are displayed in Superscript. This default setting can be deactivated in OfficeReportsàSetttingsàSignificant Characters - Superscripts