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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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.
Click to expand...
Hi Ken,

Try something like this

Format data series | options | overlap

oldchippy :
 
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.
Click to expand...
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
 
Back
Top