Skip to content
InstaCharts Logo InstaCharts

Limit Items

Too many items in the chart? Limit the chart to the top n items, or create bins of numerical values to reduce the noise in the chart.

Open the Limit Items panel from the left sidebar.

Using Limit Top Items to reduce the number of bars on the X-Axis to 7
Using Limit Top Items to reduce the number of bars on the X-Axis to 7

Limit Top Items

Limit the number of items shown to the largest n or smallest n items. Can also pick which axis is filtered and whether to group the remaining items into an Others category.

  • Limit Top Items Toggle this switch on to limit the number of items appearing in the chart

  • Max # of Items Specify the maximum number of items to show in the chart. For example, if a bar chart with 25 bars was produced, enter 10 in this field to limit it to the top (or bottom) 10 items.

  • Values to Keep Choose to either show the largest n items in the chart, or the smallest n items in the chart.

  • Axis to Limit Choose the axis that should have its items limited. The X Axis is chosen by default and may be the only option. If a grouped chart type is selected, you will be able to choose the Groups Axis to be limited.

  • Group the rest into All Others Category Check this checkbox to group any items that were too small (or too large) to pass the limit into an Others category. This option is not available for numeric or date columns.

Create bins for numerical values

This option is turned on by default, and limits the number of items drawn in the chart by putting numerical values into ranges or bins.

Ex: Instead of plotting individual numbers between 1 and 200, the software will create bins of 0-50, 51-100, 101-150, 151-200. This reduces the amount of data points plotted.

Optionally increase or decrease the amount of bins per axis by setting the # of Bins option per axis. The default value is 6 bins.

Applying bins on the X-Axis greatly reduces the number of bars drawn and increases readibility
Applying bins on the X-Axis greatly reduces the number of bars drawn and increases readibility of the chart

  • Auto Bin Turn this off for finer control of binning. By default, most numeric values on non scatterplot charts will be binned.

  • Bin X-Axis Toggle this on or off to control binning on the X-Axis

  • Bin Group Axis Toggle this on or off to control binning on the Group Axis

  • # of X Bins When Bin X-Axis is on, choose the number of bins to appear in the X-Axis. This is not an exact number.

  • # of Group Bins When Bin Group Axis is on, choose the number of bins to appear in the Group Axis. This is not an exact number.