Step by Step Instructions for Creating the Risk Assessment Template

[Monirul Islam]

1. Enter the Data in the Excel Sheet

Label the first row in Columns A, B, and C as Project Name or Activity, Probability and Consequence and fill in the name each project or activity and your estimated probability and impact values on the subsequent rows.
2. Select the Chart Style

Choose from the ribbon the Insert Tab
Select Scatter Chart
Choose Scatter Chart with only Markers (a blank chart will appear)
3. Sync the Data to the Chart

From the Chart Tools on the ribbon, select Design
Choose Select Data
Select Add to enter the data for the first project or activity
Change the Series Name to cell A1
Set Series X values to cell B2 and Series Y values to cell C2
(To enter cell values click in the chart image on the right and then click on the cell with the data.)Risk Assessment Template - Outline

Your skeleton template will now look like this, and you can proceed with formatting the legend, data points, axes, and plot area.

4. Delete the Legend (the legend is not necessary because each data point will be labeled)

Right click on the legend
Choose delete
5. Label the Data Point

Right click on the data point
Choose Add Data Label
Check the Series Name and uncheck the Y axis and then click Reset Label Text
6. Set Each Axis Range from 0 to 100Risk Assessment Axis Format

Right click each axis
Choose Format Axis
Set Min to 0
Set Max to 100
7. Key in the Title and Axis Names

Right click over the text
Select Text Edit and type
Title - Risk Assessment
X axis - Remote Probability Certain
Risk Assessment Template - Plot Area
Y axis - Insignificant Consequence Critical
8. Format the Plot Area

Right Click anywhere in the Plot Area
Choose Format Plot Area (The selection box to the left will appear.)
Click on the Gradient circle
On the first stop on the Gradient Bar switch the color to Red
Change the Direction to Linear Diagonal
Source: brighthubpm.com