Limit the number of nodes displayed in all levels

1. Click the top node of the PivotDiagram that you want to change.

2. On the PivotDiagram menu, click Options.

3. In the PivotDiagram Options dialog box, under Data options, select Limit items in each breakdown check box.

4. In the Maximum number of items box, type the maximum number of nodes that you want to show.

   For each level, a new node with an ellipsis (...) in its title bar appears in your PivotDiagram. These shapes contain the hidden nodes for each level.

Limit the number of nodes displayed in a single level

1. In your diagram, select the Breakdown shape of the level that you want to limit.

2. On the PivotDiagram menu, click Sort.

3. In the Breakdown Options dialog box, under Show, select the Limit tems in this breakdown check box.

4. In the Maximum number of items box, type the maximum number of nodes that you want to show.

   A new node with an ellipsis (...) in its title bar appears in your PivotDiagram. This shape contains the hidden data for that level.

For more information about PivotDiagrams, see Create a PivotDiagram.