Sort Asc, Desc, A-Z and Z-A work similarly in the Pinnacle graphs as in the other styles. With multi-series graphs, the sort order is applied to the values of the first series. To sort on other series, you must change the order of fields in the Chart tab's left panel.

The TopN dropdown also applies to the first series of any multi-series graph, and it applies in the direction of the currently selected sort. In other words, choosing the Top 5 when showing an Ascending graph of UnitsInStock and UnitsOnOrder keeps only the records associated with the 5 smallest values of UnitsInStock.

The Legend checkbox turns legends on or off. In some styles, switching the legend off turns on individual row labelling.

The filter dropdowns work somewhat differently for Pinnacle graphs than for the others. The first filter sieves on any of the values in the series, and can also apply conditions to the individual row labels. For instance, consider a graph of UnitsInStock, UnitsOnOrder, ReorderLevel and UnitPrice for the Products table. The following filter would restrict the graph to rows labelled with text beginning with the letters M through P, that had a value greater than 0 in the UnitsInStock series and a UnitPrice (the fourth series) greater than $50.

L Like "[M-P]*" and (V>0) and (V4>50)

The last dropdown is used to apply a filter (in the odd case it's required) to the series -- as determined by its series label. For instance, to remove the ReorderLevel series from the above graph, enter as the Legend filter:

units*

Since this filter applies to the legend and only the legend, it does not use full expression syntax. The pattern entered into the Legend filter box is matched against the Legend entries, and matching series are retained. The asterisk functions as a wildcard character.