caladanbrood
Member
Hello!
I'm hoping that I can get a pointer in the right direction for understanding bubble charts. I am happy with manipulating pretty much any others, but bubble charts just don't work well in my brain for some reason.
What I am looking for in to create is this sort of chart, from Chandoo's article on pie chart alternatives (http://chandoo.org/wp/2009/01/16/excel-pie-chart/) :
It is exactly what I am looking for on a dashboard I am working on, but I just don't get how it works. This sounds kinda pathetic but I could really do with a simple idea about what table of data I need to have to make this work!
Attached is a table of data - I want to ideally show two "pie charts" on the same chart - one for the current year, another for the total.
I hope this makes sense. I just can't get my head around bubble charts!!
Thanks,
Jon
I'm hoping that I can get a pointer in the right direction for understanding bubble charts. I am happy with manipulating pretty much any others, but bubble charts just don't work well in my brain for some reason.
What I am looking for in to create is this sort of chart, from Chandoo's article on pie chart alternatives (http://chandoo.org/wp/2009/01/16/excel-pie-chart/) :
It is exactly what I am looking for on a dashboard I am working on, but I just don't get how it works. This sounds kinda pathetic but I could really do with a simple idea about what table of data I need to have to make this work!
Attached is a table of data - I want to ideally show two "pie charts" on the same chart - one for the current year, another for the total.
I hope this makes sense. I just can't get my head around bubble charts!!
Thanks,
Jon