Select which criteria are going to be used for the X-axis, Y-axis, color code and size code axes. The use of color and size codes enables up to four criteria to be displayed on a two-dimensional chart. By selecting one criterion for the color code, the low values for that criteria are displayed in green, medium values in yellow and high values in red, using a graduated scale of color shades. Similarly, for the size code, low values are represented by a small data point and higher values by a larger one.
Use the X-axis, Y-axis, Color Code and Size Code tabs to select the appropriate criteria for formula result for each criterion.
Select whether to display the Average score for each vote or the spread (standard deviation value) for each result.
The capability to chart up to three series of data greatly enhances the scatter chart feature.
Risk Assessment: Inherent vs. Residual (2 series example)
It is possible to chart inherent likelihood & impact against residual likelihood & impact in a risk assessment. For inherent risk, the facilitator asks the participants to consider the likelihood and impact of an event occurring if no mitigating controls are in place. Then the facilitator asks them to consider the same event with existing controls in place). This scenario uses two data series (inherent and residual). A line between the points for inherent and residual values indicates the lowering of the risk once the controls are in place, as indicated below. In the illustration, the yellow squares indicate the inherent values and the pick circles the residual values. The illustration shows that having controls in place decreases either the likelihood (X-axis) of the risk or its impact (Y-axis) of both. The length of the line signifies the magnitude of the mitigation factor, from having a very minor effect (Risk #9) to a pronounced effect (Risks #6 & #12).
Set up Multiple Series
- Select the required number of series from the Number of Series drop-down.
- Click Series 1 to select the X-axis and Y-axis criteria for the first series.
- Click the Y-Axis tab and select one of the listed criteria.
- Click the X-Axis tab and choose another of the listed criteria
- To select the criteria for the second and third criteria click Series 2 or Series 3 and repeat steps 3 and 4 to select Y and X axes criteria. Note that the color code, size code and X-compare options are not available for multiple series.
- To change the plotting colors click the colored box below the Series number and choose a color form the Color Selection list window.
Item Labels: Choose between displaying the Item Label, number or nothing. The Item Label is the maximum 24-character label as defined when the items were set up. The default setting is to show the item number as this minimizes the use of screen space. The item numbers can be compared with the legend.
Item Legend: Choose between displaying the Item Label, the full item text nothing. The default setting is to show the item label.
Median or Scale Lines: Select one of two optional “crosshairs” on the screen that divide the chart into quadrants. Median of Values draws the line at the value on each scale that represents the median value of all results for each scale. It therefore creates quadrants with equal numbers in each area. The color for three lines can also be selected.
Middle of Scale simply creates a line in the middle of the X-axis and Y-axes. For example on a 1-5 scale, the line would be drawn at 3, as this is the center of the scale. On a 1-6 scale, 3.5 would be the midpoint.
Correlation: Display in text above the chart two statistical values relating to the correlation between the data points: The Coefficient of Correlation and the Coefficient of Determination.
Trend: Option to draw a trend line between all the data points and select the color for this line.
Other Data Selection Options for Scatter Chart
Change scale minimum and maximum values: From the Data drop-down, select Scale Display Range and change the maximum and minimum values to be displayed either by typing in a number or using the slide controls
Filter results by stakeholder: From the Data drop-down, select Filter for Stakeholder. This will filter the chart so the votes from one or more stakeholder groups are displayed. Select the stakeholder group form the drop down and then one or more stakeholder member groups by checking the boxes adjacent to their names.