ADDSLICEAXISLIMIT

Modifies a slice axis by limiting the number of rows that the slice returns. Optionally, specify a start point for the limit. That is, specify, for example, that an axis returns no more than two rows in addition to the first ten rows. By default, the start point is zero.

See CREATESLICEAXIS.

Syntax

=ADDSLICEAXISLIMIT("Axis", "Limit",[optional start point])

If you omit the start point, zero is used.

If you omit the limit, or specify an empty string, then no limit is applied.

Examples

In this example, cell D12 contains an axis created with the CREATESLICEAXIS function. The function limits the number of rows returned by the axis to five.

In this example, the number of rows returned is limited to five in addition to the first two rows.

=ADDSLICEAXISLIMIT(D12,5,2)