Doughnut chart with VBA
 

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.

Doughnut chart with VBA
 

i got this with the macro recorder :

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

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

Doughnut chart with VBA
 

Hi,

Try this,

ActiveChart.ChartGroups(1).DoughnutHoleSize = 25 '

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Jasoni" wrote in message
...
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.

Doughnut chart with VBA
 

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

Thanks.


"Andy Pope" kirjoitti
...
Hi,

Try this,

ActiveChart.ChartGroups(1).DoughnutHoleSize = 25 '

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Jasoni" wrote in message
...
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.