The (Plot Details) Labels Tab

The (Plot Details) Labels tab provides controls for customizing the labels of the pie chart.

Labels tab.png

Format group controls

When the Automatic check box is selected, label content is controlled by the options you've set for this group. If you want to manually edit text labels, either by in-place editing or using the Properties dialog box, you should clear the Automatic box (hint: leave at least one content option chosen so that you have something to edit).


Display the worksheet cell values as labels.


Display the percent of the total for each worksheet cell value.


Display associated X values for each pie slice. If there is no associated X column, then row numbers display.


Use this drop down list to set numeric format:†

  • Decimal:1000: 1, 1000, 1E6, 1E9
  • Scientific:10^3: 10^0, 10^3, 10^6, 10^9
  • Engineering:1k: 1.0, 1.0k, 1.0M, 1.0G
  • Decimal:1,000: 1, 1,000, 1E6, 1E9
  • Scientific:1E3: 1E0, 1E3, 1E6, 1E9
Decimal Places Use the radio button in combination with the list box to specify decimal places.
Significant Digits Use the radio button in combination with the list box to specify significant digits.

† The threshold for conversion to scientific notation is controlled on the Numeric Format tab of the Options dialog box (Preferences: Options).

Position group controls

When the Associate with Wedge check box is selected, the position of the pie slice labels is determined by the Dist. from Pie Edge setting. Units are in % of the pie chart radius.

If you opt for leader lines and you want to be able to manually drag labels around on your pie chart, you should clear this check box beforehand.

Leader Line group controls

Independent Leader Line Choose this option to independently style one or more leader lines.
Show Leader Line if Offset Exceeds (%) Leader lines will show if the distance between data labels and data points exceeds Critical Length, defined as ...

Critical Length = Specified Percent Value (%) * (Layer Height + Layer Width)/2.

Note that if you intend to drag labels to reposition them on the graph, you must clear the Associate with Wedge check box.

Connect Select Straight, 2-Segment Polyline or 3-Segment Polyline.
Style Select Solid, Dash, Dot, etc.
Width Line width is measured in points, where 1 point=1/72 inch.
Color Choose Auto (default, follows label color) or specify a color.