Doughnut chart with VBA

[Jasoni]

I have doughnut graph in my excel sheet.
Is it possible to change the size of the center circle of the doughnut
within the VBA code.
At the moment it is fixed 40% of the size of the outer doughnut but I would
like to change if according the result of my calculations.

Any ideas, couldn't find the answer from Google.

 

[Daniel.C]

i got this with the macro recorder :

Var = 60
ActiveChart.ChartGroups(1).DoughnutHoleSize = Var

HTH
Daniel

 

[Andy Pope]

Hi,

Try this,

ActiveChart.ChartGroups(1).DoughnutHoleSize = 25 '

Cheers
Andy

 

[Jasoni]

Thank you for the both of You.
How I could miss the recording ;o)

Thanks.