• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Create bubble chart - very complex

Abhay

New Member
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.
 

Attachments

  • Risk Dashboard 1.xlsx
    55.5 KB · Views: 67
See this as a start.

http://chandoo.org/wp/2013/05/28/excel-risk-map/

coming to your data,

You should first divide the numbers to 5 series (since you have have 5 types of bubbles). Once you have them, create a bubble chart. Then,
  1. Format each series in the color code you want.
  2. Create a 3x3 background with the colors you want in a separate range of 3x3 cells.
  3. Resize and make sure the cells look like squares
  4. Copy the range.
  5. Paste as image (PNG)
  6. Copy the image
  7. Select chart's plot area
  8. Paste (alternatively go to format settings and set fill > texture and use clipboard)
  9. Adjust sizes etc. as needed.
 
Back
Top