Edit Pie - Options
overview
     how to    examples    see also 

Select pie chart  > Editor > Edit Pie

Select pie chart  > Editor > Graph Options

Use to customize slice order, pie diameter, slice starting angle, and the minimum category size for separate slices.

Dialog box items

Order slices by

Default: Choose to accept the default slice order. For raw data, the slice order is increasing value for numeric and date/time data; or alphabetical for text data. (To use a value order other than alphabetical for text categories, see Ordering text categories.) For summarized data, the default slice order is always the order in which the categories appear in the worksheet; any value order is ignored.

Increasing volume: Choose to order slices from smallest to largest.

Decreasing volume: Choose to order slices from largest to smallest.

Pie Diameter

Automatic: Choose to accept the default pie diameter.

Custom: Choose to customize the diameter size, then enter a diameter size greater than 0 and less than or equal to one.

Start angle: Type the starting angle in degrees for the slices. By default, slices start at 90° (12 o'clock) and go clockwise.

Combine slices of this percent or less: Type a minimum percentage for separate slices. Categories with less than or equal to this percentage are grouped into a slice named Other, which is always placed last.

<Attributes>

<Explode>