Hi
I have some data like this
No probability Impact Risk (bubble size)
1 4 3 12 (4*3=12)
2 5 2 20
3 3 4 12
4 5 1 5
5 2 3 6
6 5 5 25
7 4 4 16
I created a bubble chart that has the probability on the horizontal axis and impact on vertical axis
Now I want to to plot both axis from 1 to 5
Now if i do that, the bubble size goes off the chart and any duplicate values get hidden..
I want to add the data labels of the numbers however because some bubbles are hidden, i can see the labels
How can i plot this correctly so it fits nicely to show both axis from 1 to 5
and resize the bubble and if there is a duplicate value, show dups values somehow (maybe show the bubble bigger, smaller) or however it fits and shows the data
How do i plot this?
I have some data like this
No probability Impact Risk (bubble size)
1 4 3 12 (4*3=12)
2 5 2 20
3 3 4 12
4 5 1 5
5 2 3 6
6 5 5 25
7 4 4 16
I created a bubble chart that has the probability on the horizontal axis and impact on vertical axis
Now I want to to plot both axis from 1 to 5
Now if i do that, the bubble size goes off the chart and any duplicate values get hidden..
I want to add the data labels of the numbers however because some bubbles are hidden, i can see the labels
How can i plot this correctly so it fits nicely to show both axis from 1 to 5
and resize the bubble and if there is a duplicate value, show dups values somehow (maybe show the bubble bigger, smaller) or however it fits and shows the data
How do i plot this?