One venture which delivers it ..

Illustrated in this sample construct at:
http://www.savefile.com/files/768019
Plotting risk map w hyperlink to risk register.xls

In a sheet: X (ie the Risk Register Reference)
Col A= Risk#s, Col B = Impact#, Col C = Likelihood#,
with data from row2 to say, row10

In D1:F1 are the labels: Score, Rank, Coord

Put in D2:
=IF(OR(B2="",C2=""),"",B2*C2)

Put in E2:
=IF(ISERROR(RANK(D2,$D$2:$D$10)),"",RANK(D2,$D$2:$ D$10))

Put in F2:
=IF(OR(B2="",C2=""),"",VLOOKUP(B2,{1,"B";2,"C";3," D";4,"E";5,"F";6,"G";7,"H";8,"I";9,"J";10,"K"},2,0 )&C2+1)

Select D2:F2, copy down to D10

Then in a sheet: Risk Map,
Impact#s: 1,2, ... 10 are labelled in B1:K1,
while Likelihood#s: 1,2, .. 10 are labelled in A2:A11

Put in B2:
=IF(ISNA(MATCH(ADDRESS(ROW(),COLUMN(),4),X!$F:$F,0 )),"",HYPERLINK("#"&CELL("address",INDIRECT("'X'!A "&MATCH(ADDRESS(ROW(),COLUMN(),4),X!$F:$F,0))),IND EX(X!$E:$E,MATCH(ADDRESS(ROW(),COLUMN(),4),X!$F:$F ,0))))

Copy B2 across by 10 cols to K2, fill down to K11 to populate the 10x10
matrix. B2:K11 will yield the required results, ie it'll "plot" the rank
numbers from X's col E in the correct cells as hyperlinks. And clicking on
the hyperlinks in the risk map will jump directly to the appropriate line in
X (ie the Risk Register Reference) for more details, as desired.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
wrote in message
oups.com...
To all interested and involved in this area. I am looking for any
ideas on creating a risk map in excel, based on risk values scored in
a risk register. Presentation-wise, I would like to develop a 10 x 10
matrix, with the two axis named consequence/impact and likelihood.
Where a risk is scored within a particular value in the Risk register
worksheet, (or a summary of risks in a worksheet), I would like a link
to that risk to be posted into the appropriate cell of the risk map.
For example, if a risk scores 5 on impact x 9 on likeliood, (score
45), in the risk register worksheet I would like a link to that risk
to appear in the appropriate cell of the risk map, i.e. in the cell
intersect of 5 and 9 of the risk map. The reason I would like for a
link to be posted is to allow the user to navigate to the risk and
view the detail, by jsut clicking on the link within the appropriate
risk map cell.

Ideally, I would like the name of the link to be ranked in accordance
to the other risks in the risk register. For example, if the risk
that scores 45 is ranked 30th out of 80 risks that have been assessed,
then in the risk map I would like the link to be named 30, and when
selected to link the user to the risk register worksheet where further
details can be viewed.

All of the above to update as risks are added to the risk register
worksheet(s).

I appreciate that this complex, but would like to know if it is
feasible.

Regards,

NiallD