Bubble chart 'plus'

Question

I saw this chart (on a sad subject):

and that made me wonder: can this be done in Excel (2010)? So four variables:

• X-axes with year
• Y-axes with country (or anything numeric - would be even better)
• bubble (100% per country) divided into 

  - illness

  - mortality

I don't have the data set available. No problem because I'm interested in a possible technique, with or without VBA.

Thanks in advance.

Answer 1

This should help you get started

http://www.andypope.info/charts/piedatamarkers.htm

Answer 2

Hi here,

Thanks for your (and Mike's) attention! This reply is mostly ... making fun. But my question still stands.

Apparently, I threw up a pretty nasty Excel chart question. Or is there a simple solution? 

Mike's answer. Was it an answer? Did he read?

By the way, Teylyn. I'm truly very fond of pie charts for some types of visualization of data: #% of the Dutch people is violent, criminal, stupid, atheist, growing hemp, is wearing wooden shoes, approves euthanasia to gain their parents savings ... Perfectly done in a pie chart.

See an excellent three level (!) pie chart on my DUTCH (!!!) site:

http://www.fhvzelm.com/files/DiversenGrafiekenAanvulling.xlsm, sheet CirkelsLabelsScheidingslijn.

It shows my whereabouts by year, #years, %years, by housing and by city. Peter Thornton gave me a breakthrough on this one. (The year section markers. I'd never seen it before! That will be a basic Excel chart feature in version 2099.)

Your 'concept' ... 

I had already thought of that approach as a last resort. A hell to do.

My dead dad would have said: "You are a meat head! Take a pencil and a piece of paper, you lazy bum. DRAW and go to the copy shop."

He was one of the first private owners of a copy machine in Holland. (The CIA, FBI, NCSI, ... overlooked him many times.) But a computer, Excel ... Way out in the 70-ties. 

Please help me with a high-er tech-er approach-ing: (changing) data ==> (changing) chart.

Answer 3

Hello,

I'm not a big fan of pie charts, but conceptually, this might work:

1. Create individual pie charts for each bubble
2. Copy each pie chart as a picture
3. format each individual bubble and use a picture fill from the clipboard

Steps 2 and 3 would need to be repeated when the data changes. You may want to look into using VBA to perform these steps.

Answer 4

Hi Mike,

I'm so sorry but I think that you didn't read my question or watched the picture. Well, perhaps you did. Or perhaps I didn't properly study the page you mention.

Of course I know about bubble charts. I name them myself in the title. And I have created tens of 'Excel-totally-impossible' charts. They are on my (Dutch!!!) site. Waterfall, double waterfall, double-double (4*) X- and Y-axis etc.

But here I found a real challenge (or I miss the simple solution). The bubbles must be divided into two (or even more - would be great) pie sectors. 

It would be great if you can help.

Answer 5

Hi,

You can do it with a couple of mouse clicks in Excel. Bubble charts are in the X Y Scatter group of charts. have a look at this link.

http://peltiertech.com/Excel/ChartsHowTo/HowToBubble.html