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.

Ken Wrote:
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.
Hi Ken,

Try something like this

Format data series | options | overlap

oldchippy :)


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=568081

Ken, I guess that a doughnut chart can give u what y'r looking for. You may
like to check out Andy Pope's website
http://www.andypope.info/charts/pies.htm for inspiration and instructions how
to do it.
HTH,
Henk

"Ken" wrote:

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.

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