Navigation:


DISCUSSIONS > IIA GENERAL DISCUSSION AREA [ REFRESH ]
Thread Title: likelihood/impact
Created On Monday September 10, 2012 11:09 AM
  likelihood/impact
  likelihood/impact
  likelihood/impact


WAGirl


Posts: 14
Joined: Jan 2012

Monday September 10, 2012 11:09 AM

User is offline View thread in raw text format

Does anyone know how to create a significant likelihood/impact quadrant chart in excel using scores from data summary? Any help would be greatly appreciated. Thanks.

Reply
Quote
Top
Bottom



Mark R. Simmons


Posts: 133
Joined: Nov 2003

Wednesday September 26, 2012 5:10 PM

User is offline View users profile View thread in raw text format

An Excel guru might know a better way. This is about the best I think I ever got with Office 2007. I found that while do-able, it wasn't worth the effort most of the time, but here's how I went about it:

Create a table with risk factors in first column, likelihood scores in second column and impact scores in the last column.
Chart the data columns as a scatter diagram (likelihood on "y" axis"; impact on "x" axis).
Basic chart will yield a data point for the likelihood/impact coordinate for each risk factor.
Basic chart gives you a choice of background heat maps that you can customize.

Cons:
* you won't see the individual risk factor labels in the chart (only the related x/y datapoints), but you can manually force the labels by altering the chart's properties.

* if two risk factors have the same data point, you will only see one point. If you've substituted risk factor labels, one will overwrite the other.

A bar chart or stacked bar chart with a heat map running left (green) to right (red) may be the easier option in Excel





Edited: Thursday September 27, 2012 at 9:02 AM by Mark R. Simmons

Reply
Quote
Top
Bottom



Awdit


Posts: 33
Joined: Aug 2008

Thursday November 08, 2012 2:42 PM

User is offline View thread in raw text format

Mark's way of doing it works. I would do heat maps: one with inherent risks and one with residual risks.

Reply
Quote
Top
Bottom

DISCUSSIONS > IIA GENERAL DISCUSSION AREA [ REFRESH ]
The Institute of Internal Auditors • 247 Maitland Avenue Altamonte Springs, FL. 32701-4201 USA
+1-407-937-1100 • FAX +1-407-937-1101 • www.theiia.org