How do I set up a circle within a circle chart?

[Ken]

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.

 

[oldchippy]

I would like to create a chart in which one large circle represents th
total
amount of something. That is, it represents 100%. I'd like to then hav
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 smal
circle
could be female residents, or left-handed people. It would be neat t
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 :

 

[HEK]

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

 

[Tushar Mehta]

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