View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Daniel.C[_2_] Daniel.C[_2_] is offline
external usenet poster
 
Posts: 105
Default 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.