vk7
Member
I am finding someway to group bubbles inside a bubble chart. Just looking for some inputs on that. I have attached an excel sheet with this message which contains the bubble chart.
The condition is, if there is any bubble that falls in the below range
- From -2.5 to -0.5 and 0.5 and 2.2 then there should be a new layer cover those bubbles with some label (i.e Very High)
- From -1.5 to -2.5 and -1 to -2 then there should be a new layer covering those bubbles with some label (i.e Optimal)
I have also attached a screenshot on how it should like (so that it gives more idea). I have just added a circle in the screenshot covering the bubbles but I would also need some label to the circle for identification.
The condition is, if there is any bubble that falls in the below range
- From -2.5 to -0.5 and 0.5 and 2.2 then there should be a new layer cover those bubbles with some label (i.e Very High)
- From -1.5 to -2.5 and -1 to -2 then there should be a new layer covering those bubbles with some label (i.e Optimal)
I have also attached a screenshot on how it should like (so that it gives more idea). I have just added a circle in the screenshot covering the bubbles but I would also need some label to the circle for identification.