Home 
Search 
Today's Posts 
#1




How do I set up a circle within a circle chart?
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 lefthanded people. It would be neat to be able to have more than one subset circle, but I'd settle for one for now. 
#2




How do I set up a circle within a circle chart?
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 lefthanded 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 
#3




How do I set up a circle within a circle chart?
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 lefthanded people. It would be neat to be able to have more than one subset circle, but I'd settle for one for now. 
#4




How do I set up a circle within a circle chart?
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 lefthanded 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.tusharmehta.com Excel, PowerPoint, and VBA addins, tutorials Custom MS Office productivity solutions 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Circle on chart different in print preview  Charts and Charting in Excel  
Activating a Chart object  Charts and Charting in Excel  
Urgent Chart Assistance  Charts and Charting in Excel  
Urgent Chart Questions  Excel Discussion (Misc queries)  
Urgent Chart Assistance Requested  Excel Discussion (Misc queries) 