I have built a scatter chart to show as a risk heat map, where Y-axis is Impact and X-axis is Likelihood. Couple challenges I have and could really use some help. Some info on the risks.
-Each has an individual risk ID #. No duplicates exist.
-Impact rating is either 1,3,5,7,or 9
-Likelihood rating is either 1,3,5,7,or 9
1) How do you prevent risks that have the same impact and likelihood rating from overlapping on the scatter chart?
2) Is there a way to conditionally format the label market based on a value from my data? If so, how would I do this?
-Each has an individual risk ID #. No duplicates exist.
-Impact rating is either 1,3,5,7,or 9
-Likelihood rating is either 1,3,5,7,or 9
1) How do you prevent risks that have the same impact and likelihood rating from overlapping on the scatter chart?
2) Is there a way to conditionally format the label market based on a value from my data? If so, how would I do this?