• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 128
  • Last Modified:

Risk matrix

I'm working on summarizing a risk register into a risk chart and having issues with the counting the number of probability and impact numbers and having them show up in the right spaces on the summary chart.

Should I use a vlookup?

If the prob is 1 and the impact is 1, then a number 1 should show up in the correct grid, but how do I do them individually and then summarize from the risk register.
0
ckwillGWU
Asked:
ckwillGWU
  • 3
  • 2
2 Solutions
 
ckwillGWUAuthor Commented:
0
 
FarWestCommented:
I think you can use pivot table to make summaries and counts of risks for each project (one pivot  table will make them all) and do vlookup from the table to project and total summaries.

in "team" means "project" in risk register?
0
 
ckwillGWUAuthor Commented:
Yes, team and project are the same. I can't see a clear picture on how to use a pivot table to do this.
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

Assuming that PF means PMO in the register and assuming that you only want to count open and closed,  you can do this:

1. On the Risk Register, remove all empty rows.
2. Click in the Risk Register, then Insert > Pivot Table
3. In the Pivot table field pane drag "Team" to Column Labels
4. Drag "Status" to Row Labels
5. Drag "Status" again to Values.

cheers, teylyn
0
 
FarWestCommented:
please check this with a sample
please note that a column is added to the register to present one value for both prop and impact
to have count for distinct values
Risk-Register2-Pivot.xlsx
0
 
ckwillGWUAuthor Commented:
This response was partially answered, but probably too much to be done on one question. I will do more research and testing. Thank you all.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now