Dot plot

Discrete category dots. What the dot plot is for, the data it needs and every option it has.

2 min read

On this page

Discrete category dots. It sits in the Comparison group of the widget library.

Example dot plot on a BankSync dashboard
An example dot plot drawn with sample data. Hover for values and switch between examples.

When to use it#

Use a dot plot to compare values across categories where zero is not a meaningful starting point, such as the average transaction size per merchant or the closing balance of each account. The axis fits the data rather than starting at zero, so small differences between categories stay visible. A colour field compares a few groups, such as this year against last.

When to pick something else#

  • Totals where the length from zero matters? Use a Column chart or Lollipop.
  • Seeing how individual values spread within each category? Use a Strip plot or Beeswarm.
  • A trend over time? Use a Line chart.

The data it needs#

Pick these in the Data tab of the inspector. BankSync suggests a column for each when your source has an obvious match.

FieldNeededPickNotes
X axisYesa category or a date
Y axisYesa number
SeriesOptionala category
ColorOptionala category

Rows that share a category are combined before drawing: choose Sum, Average, Count, Min or Max on the value field. See Binding data.

Dot plot options#

This chart has no options of its own; everything on its Style tab is the shared chart styling below.

Shared chart styling#

Every chart also has the shared styling options. These apply to this one:

Messy data#

  • By default values in the same category and colour are added together into one dot. Turn aggregation off to plot each row as its own dot.
  • Overlapping dots are nudged sideways, never along the value axis.
  • Rows without a number are skipped; if none are left you see "No numbers to show".
  • Very large tables are thinned evenly to 2,000 dots.
  • When categories don't fit, the rarest fold into "Other (n)". More than nine colour groups keep the eight largest and put the rest in "Other".

On a phone#

Long category names switch it to horizontal rows, and more categories fold into "Other".

Use this page with your AI assistant

Every BankSync doc is available as plain Markdown for agents and LLMs.