Data Labels in Pie Chart

[Mr.FutureCoder]

Hi,

My current Macro deletes the existing series and adds new series by assigning .XValues and .Values in Pie chart. Problem is that the data labels overlap each other and some data label words break(some letters goes in second line instead of first). I need help to adjust data labels such that they do not overlap each other and words do not break.

 

[Worf]

Take a look at this:

http://www.ozgrid.com/forum/showthread.php?t=60483<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
http://www.excelforum.com/excel-programming/372162-solved-postioning-of-labels-on-charts-using-vba.html<o></o>
<o></o>
http://www.excelbanter.com/showthread.php?t=33600<o></o>

 

[Mr.FutureCoder]

Thanks for your reply. I have checked the links and came to know that i cant stretch the data labels and i need to use text boxes instead of data labels. Is there any macro which can insert the text box at the desired location on pie chart with the text i want. Appreciate your help. Thanks.

 

[Worf]

Hi<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
<?xml:namespace prefix = st2 ns = "urn:schemas-microsoft-comffice:smarttags" /><st2:PersonName w:st="on"><?xml:namespace prefix = st1 ns = "urn:schemas:contacts" /><st1:GivenName w:st="on">John</st1:GivenName> <st1:Sn w:st="on">Walkenbach</st1:Sn></st2:PersonName>’s Power Utility Pak has a feature called chart data labeler which may do what you want.<o></o>
It costs U$40 but you can download a 30-day trial:<o></o>
<o></o>
http://spreadsheetpage.com/index.php/pupv7/trial<o></o>