Bubble Charts

**Cath** · 07-02-2010, 07:02 AM

Hi all,
I have a bubble chart, but have realised that if 2 rows have the same values then you can't differentiate between the bubbles as they are on top of each other, is there a way around this please?
Thanks
Catherine

**Andy Pope** · 07-02-2010, 07:06 AM

you could try sorting the data on x,y and then size in descending order.

**Cath** · 07-02-2010, 07:25 AM

Thanks for getting back to me........

itemid/name,Business Benefit,Effort/Cost,Risk
test 5 2 1
test2 5 2 1

If all the values are the same though, I'm not sure how that will work?
Am I missing something?

**Andy Pope** · 07-02-2010, 07:30 AM

It will not if ALL the values are the same.

You either have to manipulate the data values so they do not obscure each other.
Or use semi transparent bubbles.
Or use alternative chart style.