Doughnuts (2000)

Topic

New Reply

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.

Reply | Quote

Replies

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.

Reply | Quote

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.

Reply | Quote

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

Andrwe C

Reply | Quote

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..

Reply | Quote

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

Reply | Quote

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.

Reply | Quote