Excel 2007 : Excel 2007 - Pie Charts - Data Labels - Best Fit - Moving labels next to Legend

Hi
I am a very, very new Excel user, so pardon if this is a stupid question. I have created a pie chart and for each wedge there is a legend with coloured labels. I wanted to add the percentage as well, so I go to Data Labels, click Percentages and Best Fit, and voila, there are my percentages, but they are outside the Pie Chart and I want them to be NEXT to the legend.

1% small red block - Manufacturing
5% small blue block - Medicine, etc.

Can anyone help? I could send you the chart.

PS: When I got the chart, it was like that, except the percentages were skew, so I fiddled and now nothing works properly. I have tried to make the chart area smaller and bigger.

Thank you very much in advance.

Hi,

Instead of using "Best fit", select "center" or "inside end". as 1% is very small area as compared to 99%, so best fit option is forcing labels out of pie chart. If you are facing this issue with all labels, then plz send sheet I can help you

regards