I need to creat Bubble charts similar to screenshot pasted in attached excel file.
I would have data similar to the data entered in it. Few requirements:
1. Bubble color should be as per risk type.
2. Bubble should be plotted considering rating for Risk Impact and Risk Likelihood.
3. High, Medium and low priority areas should be highlighted in chart.
4. Quarter wise and year wise should be available.
I believe this seems to be very complex so that asking for help from you guys.
I would have data similar to the data entered in it. Few requirements:
1. Bubble color should be as per risk type.
2. Bubble should be plotted considering rating for Risk Impact and Risk Likelihood.
3. High, Medium and low priority areas should be highlighted in chart.
4. Quarter wise and year wise should be available.
I believe this seems to be very complex so that asking for help from you guys.