Skip to end of metadata
Go to start of metadata

The bubble chart and bar chart can display thresholds. Thresholds can be used to filter values in a chart, which can be useful for analyzing data. Values that do not meet a threshold are not shown in the chart. In a bar chart only horizontal thresholds can be set, in a bubble chart horizontal thresholds ("thresholds y-axis") as well ass vertical thresholds ("thresholds x-axis"). Multiple thresholds can be set in a chart.

Following types of thresholds can be defined:

  • upper bound (for showing values below the threshold, "Below" constraint)
  • lower bound (for showing values above the threshold, "Above" constraint)
  • top number (for showing the top X values, "Top" constraint)
  • bottom number (for showing the bottom X values, "Bottom" constraint)


Bubble chart with an y-axis threshold with "Above" constraint


Thresholds cannot be used when a chart is in aggregation mode. After you have added thresholds and then enable the aggregation mode, the thresholds will disappear. If you deactivate the aggregation mode, the defined thresholds will appear again.

Setting thresholds

  1. Select the chart, and click  to open the chart's Settings window.



  2. On the Filter tab, click the cross  next to Enable thresholds to enable them.

  3. Under Tresholds, Tresholds x-axis and/or Tresholds y-axis, define the threshold(s) of your choice.

    1. Under Name, enter the name for the threshold.

      You can also rename a threshold after it has been added by selecting its name in the diagram, and then typing the new name.


    2. Under Constraint, select the type of constraint for the threshold.

    3. Under Value, select the value for the constraint.

      When using the "Above" or "Below" constraint, you can change the threshold value by moving the threshold line in the diagram after it has been added.

    4. Under Enabled, click the cross  next to the threshold.

    5. To add additional constraints, click next to an existing constraint.

  4. Close the Settings window.

Deactivating and removing thresholds

Thresholds can be removed again or (temporarily) deactivated. When deactivated, the defined thresholds will disappear from the chart, but will not be removed. The moment you reactivate thresholds, the defined thresholds will reappear in the chart. When you remove a threshold it is really removed from the chart. You need to set it again in order to use it.

To deactivate thresholds:

  1. Select the chart, and click  to open the chart's Settings window.

  2. On the Filter tab, click the check mark  next to:

    Enable thresholds if you want to deactivate all defined thresholds.

    One or more of the thresholds below Tresholds x-axis if you want to deactivate specific thresholds for the x-axis.

    One or more of the thresholds below Tresholds y-axis if you want to deactivate specific thresholds for the y-axis.

  3. Close the Settings window.

To remove a threshold from the chart:

  1. Select the chart, and click  to open the chart's Settings window.

  2. On the Filter tab, under Tresholds x-axis and/or Tresholds y-axis, click  next to each threshold that you want to remove.

  3. When you are ready, close the Settings window.