Moving an Individual Pie Slice Label in Excel 2007:-


In a pie chart that has long category names and many slices, you may not be able to find an angle of rotation that enables all the labels to have sufficient room. In this case, you need to move an individual pie slice label.

The first time you click a data label; all the data labels are selected, as shown in the Figure (given below). At this point, you can use icons on the Home ribbon to change the font or font size. A second click on a data label selects only that particular label. You can click the border of the label and drag it to a new position. If the Leader Lines option remains selected, Excel automatically connects the label and the pie slice with a leader line.



(After the first click on a data label, all labels are selected. You can use the Home ribbon icons to format all labels.)

In the Figure (given below), the label for the keyboard has been moved so that it does not crash into the label for the trigger assembly.



(After a second single-click, only one label is selected. You can drag an individual data label into a new position.)