Results 1 to 7 of 7
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Doughnuts (2000)

    I want to create concentric circles of specific proportions. I am trying to do this with a doughnut chart, but I need to get rid of the empty area in the middle. Any suggestions? (I know this can be done with drawing tools, but I want it to be linked to the data.) Thanks, Andy.

  2. #2
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Doughnuts (2000)

    I thought you were talking up breakfast here...just kidding. If you right click and select format chart area on a doughnut chart, the fourth tab is "Options". In this tab you can change the size of the hole in the middle, even all the way to nothing, at which point it resembles a pie chart.

  3. #3
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Doughnuts (2000)

    The hole in the doughnut can only be reduced to 10, not zero. This would be okay if I wanted to treat the hole as a data point, but I need to shade in the hole (which Excel treats as the Plot Area)! Any other ideas? Is there a different chart type that could be 'co-erced' into looking like a doughnut (without a hole?! - which I suppose is a bun?) Andy.

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Doughnuts (2000)

    There is a Radar type which might be adaptable to your needs.

    Andrwe C

  5. #5
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Doughnuts (2000)

    Excellent!! I used the filled radar with lots of duplicated values to force the series into circles. All I needed to do then was change the Series order and the fill colour for each one, and remove the labels and axes. Whe'hay! Thanks very much..

  6. #6
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Doughnuts (2000)

    You can reduce it to zero by entering 0 instead of using the up/down spin button.

  7. #7
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Doughnuts (2000)

    You are right, but I don't think that this resolves the problem. If you do this then it converts to a pie chart. I think the solution remains to use a radar chart.

Posting Permissions

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