Label Doughnut-Chart outside
Hi, Does anyone has a VBA Script to label a doughnut chart outside the actual chart with a leader line? Excel only gives you this option with a pie chart. Thanx for any help. Steeplechase -- Steeplechase ------------------------------------------------------------------------ Steeplechase's Profile: http://www.excelforum.com/member.php...o&userid=31066 View this thread: http://www.excelforum.com/showthread...hreadid=507404 |
Label Doughnut-Chart outside
Hi,
If this is a single ring donut then you do not need any code. Assuming your data is in A1:B5, labels in column A. Series name and values in column B A1:= B1:=Name A2:=S1 B2:=1 A3:=S2 B3:=2 A4:=S3 B4:=3 A5:=S4 B5:=4 Add a copy of B1:B5 into C1:C5. Now select the range A1:C5 and create a donut, which will have 2 rings. Select the outer ring and change its chart type to Pie. The pie will cover the donut for the moment until we finish formatting the chart. Select the pie chart and add data labels make sure you check the leader line option. On the patterns tab set the border and fill to none. This will cause the pie to vanish but the data labels will remain. With only 4 slices you will probably need to drag a data label away from the donut in order to see the leader lines, but they are there now. Cheers Andy Steeplechase wrote: Hi, Does anyone has a VBA Script to label a doughnut chart outside the actual chart with a leader line? Excel only gives you this option with a pie chart. Thanx for any help. Steeplechase -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Label Doughnut-Chart outside
Hello There! Thanx for your help. That actually works very well. Is there a way in VBA to do those steps automatically? For example by just selecting a graph and clicking on one single button? I appreciate your help. Steeplechase -- Steeplechase ------------------------------------------------------------------------ Steeplechase's Profile: http://www.excelforum.com/member.php...o&userid=31066 View this thread: http://www.excelforum.com/showthread...hreadid=507404 |
Label Doughnut-Chart outside
The simplest way to generate the code would be to make use of the macro
recorder. Just turn it on and perform the required steps in order to format your chart. For more information see Tushar's page, http://tushar-mehta.com/excel/vba/be...rder/index.htm Cheers Andy Steeplechase wrote: Hello There! Thanx for your help. That actually works very well. Is there a way in VBA to do those steps automatically? For example by just selecting a graph and clicking on one single button? I appreciate your help. Steeplechase -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
All times are GMT +1. The time now is 03:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com