In article ,
says...
I would like to create a chart in which one large circle represents the total
amount of something. That is, it represents 100%. I'd like to then have one
or more circles inside it to represent subset(s) of the large circle. For
example, the large circle might be all people in a zip code. The small circle
could be female residents, or left-handed people. It would be neat to be able
to have more than one subset circle, but I'd settle for one for now.

Create a bubble chart with multiple series, where each series consists of
only 1 data point. Position them (x and y values) and assign them bubble
sizes as desired.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions