Creating Risk Heat Map without VBA?

High all

I am trying to create a Heat Map for Risk in a spreadsheet that auto populates. Very simple dataset and I can convert my values to numeric if that makes the graph easier. Data Set is basically as follows:

Column 1 - Risk Description
Column 2 - Impact (score of 1-5)
Column 3 - Probability (score of 1 to 5)
Column 4 - Risk Indicator (Col 2 x Col 3 to give score out of 25.

Looking to create Heat map with upper right being my highest risk and lower left the improbables or low impact. I should mention that my VBA is as good as my Latin skills, i.e. Zero! so looking for a way of doing it through excel, either suggested or inbuilt charts.

As always, thanks in advance.

TexasKersh

Hi mate,

Just a thought, shouldn't you also incorporate an environment of where the risks might occur, as in you could go on forever...:

Hospital
Risk Description - Contamination, Fire, Manual Handling, BioHazard

Factory
Risk Description - Fire, Manual Handling, Transport, Machinery

get my drift?

It might be easier to construct that way

Hi mate,

Just a thought, shouldn't you also incorporate an environment of where the risks might occur, as in you could go on forever...:

Hospital
Risk Description - Contamination, Fire, Manual Handling, BioHazard

Factory
Risk Description - Fire, Manual Handling, Transport, Machinery

get my drift?

Or, provide an example scenario where you would be basing your risk assessment on

It might be easier to construct that way

Hi

Should have mentioned before. The sheet does contain more information such as type of risk (commercial, financial, reputation etc). These are all reported as a percentage up to the seniors, i.e. of x number of risks, 20% are financial, 40% are reputation etc. The heat map is for import into a Powerpoint presentation for a report. You know how senior want a simple one pager. Function of this Heat map would be for seniors to see on a one page that there are no risks above a certain level etc.