An exploding Pie or bubble chart

[PeterGammage]

Looking to graphically represent some data, which is an expansion of some data. A little like a pie of a pie, however I need a pie for all peices of the pie.

The example below is a complex version of this - however you should see that the bubble in the center represents a total whilst the bubbles linked to it are break downs of that total, and the bubbles linked to them are the breakdowns of them. I´m not looking to be as complex as this - just one level of explosion of the bubble or pie will do - but I do want to do it for more than one section (ie not just a pie of a pie as it can only expand one section)

http://www.guardian.co.uk/business/interactive/2009/sep/16/public-spending-larry-elliott?INTCMP=SRCH

All ideas, thoughts or considerations greatly appreciated!!

 

[PeterGammage]

Steve (assuming its Steve from the login ID) I don't have data as I approached it from a different angle.

I used a bubble chart - big bubble in the middle being the sum and external bubbles being the individual elements

 

[Steve=True]

That is how i tackled the problem too.

I need to move some labels around and then it should be ready to go.

I will probably create a demo/tutorial for it but could use a beta tester.

send me an email to steve hat cpsre daught com

Change hat to at and daught to dot

I can shoot you a copy.