Setting the DonutHoleSize property to less than 10

Question

Excel allows the user to set the size of the hole in the donut chart between 0% and 90%. In VBA, the accepted range is from 10% to 90%.

I can write a macro that creates this code:

ActiveChart.ChartGroups(1).DoughnutHoleSize = 0

However, it causes an error if I try to restart it. Is there any other way to set the DoughnutHoleSize value to less than 10 in VBA? See the image below for the type of plot I'm trying to build.

Answer 1

I see no way to set DoughnutHoleSize to zero through VBA.

However, you can only change the innermost series to a pie chart. This will fill the middle and save the outer series as donuts.

ActiveChart.FullSeriesCollection(1).ChartType = xlPie