Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 3rd 06, 08:24 PM posted to microsoft.public.excel.charting
Ken Ken is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 590
Default 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 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.

  #2   Report Post  
Old August 3rd 06, 08:36 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 1
Default 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 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

  #3   Report Post  
Old August 3rd 06, 10:18 PM posted to microsoft.public.excel.charting
HEK HEK is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 46
Default 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 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Circle on chart different in print preview Kwalityguy Charts and Charting in Excel 1 April 25th 06 09:09 PM
Activating a Chart object Hari Prasadh Charts and Charting in Excel 6 August 2nd 05 07:22 PM
Urgent Chart Assistance Brent E Charts and Charting in Excel 1 May 10th 05 09:09 AM
Urgent Chart Questions Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM
Urgent Chart Assistance Requested Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM


All times are GMT +1. The time now is 12:52 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017