Overview
Creating a Risk Matrix
The Source Table:
The Result:
Macro combination:
Wrap the source table manually or a macro generated with the
Pivot Table
macro.
Configure Pivot Table.
Macro configuration:
Pivot Table:
Row Labels
Likelihood
Column Labels
Impact
Calculated Column
Page
Operation Type
Count
Additional parameters:
Hide totals
of the pivot table.