Limit the number of nodes in PivotDiagram levels

You can choose how many nodes to display in a single level or in all levels of your PivotDiagram. This is helpful if you are working with large worksheets, tables, or views and you don't need to see all of the data broken into separate nodes.

For example, you may want to show only the first 5 nodes in a level of salespeople or the first 20 nodes in a level of orders.

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.