| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a doughnut chart with different sizes for each ser | Charts and Charting in Excel | |||
| can the doughnut chart key be in words | Charts and Charting in Excel | |||
| what do you use a doughnut chart for | Charts and Charting in Excel | |||
| Label Doughnut-Chart outside | Charts and Charting in Excel | |||
| Office Web Components; combined chart Doughnut/Scatterline doesn't work | Charts and Charting in Excel | |||
Linear Mode
