+ Reply to Thread
Results 1 to 6 of 6

Circle within Circle Chart

  1. #1
    Registered User
    Join Date
    06-24-2011
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    6

    Thumbs up Circle within Circle Chart

    Hi,

    I have a series of 3 numbers like 100,60 and 30. I want to draw circle chart depending upon these values.
    So the biggest circle should be of lets say size 100. Another should be of size 60 but within the bigger one.
    Then third one should of of size 30 but again it should be inside the 2nd one.
    So in other words, I want to show a team of 100 as a big circle, then 60 out of those 100 are in a specific process as a smaller circle within that and then finally 30 out of those 60 are reporting to me and should be as a smallest circle within the smaller one.
    Also I want if I change the values next month, chart should automatically be updated as per the new values.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Circle within Circle Chart

    Use a bubble chart where the numbers are the Size. The x and y values can all be the same.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    06-24-2011
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Circle within Circle Chart

    Hi,
    Did not get your point. If I draw a bubble chart on just one series how can they be placed one within another?
    I tried but it is showing just 2 bubbles, bigger and smaller and they both are seperate. Middle one is invisible.

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Circle within Circle Chart

    In the example I set the fill to vary by point.

    The size is by Width and factored by 300 to give larger circles
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    06-24-2011
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Circle within Circle Chart

    yes this is what I need...many thanks...
    Just a small question....I am trying to create a bubble chart on your table but not able to....
    What additional you did to look it like this.....if you could make me understand in a couple of lines....

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Circle within Circle Chart

    I did detail.

    Post your workbook, not a picture, of what you have managed so far.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Drawing a circle on a chart
    By 10999989 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-26-2013, 07:17 AM
  2. Replies: 4
    Last Post: 12-17-2012, 11:45 PM
  3. [SOLVED] How do I set up a circle within a circle chart?
    By Ken in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-04-2006, 07:45 AM
  4. Circle on chart different in print preview
    By Kwalityguy in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-25-2006, 04:15 PM
  5. [SOLVED] how do i make a "dashboard style" chart (semi circle & pointer)
    By SamanthaGaszczak in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-16-2005, 05:35 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1