Action Level Exceedance – Crosstab Row and Column Header Colors

<< Click to Display Table of Contents >>

Navigation:  Professional > Reports > Crosstab Reports > Display Formatting >

Action Level Exceedance – Crosstab Row and Column Header Colors

For general action level formatting, see Action Level Exceedance - Display Formatting.

 

When creating a crosstab for action level exceedances, use Display > Exceedance (custom) on a header to customize background (cell) and foreground (character) colors and formatting.

For row headers, both the row headers and tabbed data exceedances will show matching formatting.

For column headers, tabbed data exceedances are colored, but column headers are not colored until the crosstab is exported to Excel. In the Excel output, the column headers and tabbed data exceedances will show matching formatting.

 

Example – Row Header Custom Exceedances

 

PRO_Reports-Crosstab-ALE-Row-Header-Setting

 

The crosstab output using the row header exceedances settings above is shown below.

 

pro_reports-crosstab-ale-row-header-output-example_zoom65

 

 

Example – Column Header Custom Exceedances

 

PRO_Reports-Crosstab-ALE-Column-Header-Setting

 

The crosstab output using column header exceedances settings above is shown below/

 

pro_reports-crosstab-ale-column-header-output-example_zoom70

 

The crosstab output above exported to Excel with colored column header exceedances is shown here:

 

pro_reports-crosstab-ale-column-header-excel-example_zoom60