Bubble chart
Bubble chart places points by two numeric columns and sizes each one by a third, so one chart compares three measures for each row or group.
Compare drink price, sales and revenue
Four drinks are placed by Price and Cups and sized by Revenue. Juice has the largest bubble at 125, even though Coffee sold more cups, because Juice costs more.
Bubble chart interactive example
Loading interactive example…
The live example needs a desktop screen. The result it produces is shown here, and the explanation and settings below work on any screen.
| Drink | Price | Cups | Revenue |
|---|---|---|---|
| Tea | 2 | 20 | 40 |
| Coffee | 3 | 30 | 90 |
| Cocoa | 4 | 10 | 40 |
| Juice | 5 | 25 | 125 |
- Open the dropdown at the top of Properties. It shows
Bubble chart. ChooseScatter plot. All points now have the same size. - Choose
Bubble chartagain. In the Data tab, change Bubble size to another numeric column. - Open the Design tab and expand Horizontal axis. This example fixes the axis range, so you can see where to change it.
When to use
Use Bubble chart to add a third measure to a scatter plot when that measure changes the story, as revenue does here. Size is harder to judge than position, so keep to a few bubbles. When two measures are enough, use Scatter plot.
Inputs
- Table
Accepts: Tables.
Accepts one connection on this port.
Settings
- Points
Plots one point per row, or one point per group with calculated coordinates.
Default:
Individual rowsOptions: Individual rows, Grouped summaries.
- X coordinate
Column on the horizontal axis. Individual rows and density plots need numbers, and grouped points can count other fields. Auto picks one with varied values.
- Y coordinate
Column on the vertical axis. Individual rows and density plots need numbers, and grouped points can count other fields. Auto picks one with varied values.
- Bubble size
Column that sets bubble size. Individual rows need numbers, and grouped points can count other fields.
- Color by
Optional column that colors the points.
41 more settings
- Sort by
Order of the plotted points: by group, X coordinate, Y coordinate or bubble size.
Default:
DefaultOptions: Default, Group, X coordinate, Y coordinate, Bubble size.
- Period size
Number of units in each period. Hours, minutes and seconds count fixed intervals from 1970-01-01 in the chart's time zone. Calendar periods follow local boundaries.
Default:
1- Source timezone
IANA time zone for timestamps without an offset, such as Europe/Copenhagen. Ambiguous local times need an explicit offset.
Default:
UTC- Chart timezone
IANA time zone used for grouping and display. Vista filters keep their own time zone.
Default:
UTC- Week starts
Day the week starts on.
Default:
MondayOptions: Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday.
- Fiscal year starts
Month the fiscal year starts in. Sets quarter and year boundaries.
Default:
JanuaryOptions: January, February, March, April, May, June, July, August, September, October, November, December.
- Title
Title shown inside the chart. Leave empty to hide it.
- Title color
Color of the title.
- Title size (Advanced title)
Size of the title, in pixels.
Default:
24- Title alignment (plot)
Alignment of the title.
Default:
LeftOptions: Left, Center, Right.
- Title (Horizontal axis)
Title of the X axis. Leave empty to use the field names. An empty prefix or suffix uses the vertical axis formatting.
- Range
Sets fixed limits for the value axis.
Default:
AutoOptions: Auto, Min only, Max only, Min & max.
- Min
Lowest value on the axis.
Default:
0- Max
Highest value on the axis.
Default:
100- Display units
Unit for value labels. Every tick is divided by it.
Default:
NoneOptions: None, Thousands (K), Millions (M), Billions (B).
- Prefix
Text before each value label.
- Suffix
Text after each value label.
- Label size (Advanced horizontal axis)
Size of the X axis labels, in pixels.
Default:
12- Label angle (Advanced horizontal axis)
Angle of the X axis labels. Auto turns them when they don't fit.
Default:
AutoOptions: Auto, 0°, 45°, 90°.
- Title size (Advanced horizontal axis)
Size of the X axis title, in pixels.
Default:
12- Title distance (Advanced horizontal axis)
Extra space between the X axis labels and the title, in pixels.
Default:
4- Title (Vertical axis)
Title of the Y axis. Leave empty to use the field names.
- Label size (Advanced vertical axis)
Size of the Y axis labels, in pixels.
Default:
12- Label angle (Advanced vertical axis)
Angle of the Y axis labels.
Default:
AutoOptions: Auto, 0°, 45°, 90°.
- Title size (Advanced vertical axis)
Size of the Y axis title, in pixels.
Default:
12- Title distance (Advanced vertical axis)
Extra space between the Y axis labels and the title, in pixels.
Default:
4- Show tooltip
Shows or hides values when you hover over a mark.
Default:
true- Tooltip
Text shown when you hover over a mark. Write it in the editor and insert values from Values.
- Values
Values you can insert into the text. Each row calculates a value from a source field or, in charts, shows a chart value, and can have its own number or date format.
- Tooltip dates
How dates are written in tooltips.
Default:
IsoOptions: Auto, Iso, Date, Datetime, Custom.
- Background
Card background color. Auto follows the theme.
- Plot padding
Space between the card edge and the chart, in pixels.
Default:
0- Grid lines
Shows or hides grid lines.
Default:
false- Axis frame
Shows or hides the axis lines around the plot.
Default:
true- Frame sides
Edges of the plot that get an axis line.
Default:
Bottom & leftOptions: Bottom, Left, Bottom & left, Full box.
- Axis titles
Shows or hides the titles on both axes.
Default:
true- Tick color
Color of the axis labels.
- Axis title color
Color of the axis titles. Auto matches the axis labels.
- Frame color
Color of the axis lines.
- Corner radius (px)
Corner radius in whole logical pixels.
Default:
0- Border width (px)
Border width in whole logical pixels.
Default:
0
Bubble chart FAQs
- What is the difference between a bubble chart and a scatter plot?
- A bubble chart adds Bubble size, which sizes each point by a third column. Switching to Scatter plot gives all points the same size.
Chart your data. Build it in Vista.
Vista opens in your browser, with no account.