Documentation

    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.

    The live example needs a desktop screen. The result it produces is shown here, and the explanation and settings below work on any screen.

    Result
    DrinkPriceCupsRevenue
    Tea22040
    Coffee33090
    Cocoa41040
    Juice525125
    1. Open the dropdown at the top of Properties. It shows Bubble chart. Choose Scatter plot. All points now have the same size.
    2. Choose Bubble chart again. In the Data tab, change Bubble size to another numeric column.
    3. 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

    1 port
    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 rows

    Options: 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: Default

    Options: 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: Monday

    Options: Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday.

    Fiscal year starts

    Month the fiscal year starts in. Sets quarter and year boundaries.

    Default: January

    Options: 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: Left

    Options: 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: Auto

    Options: 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: None

    Options: 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: Auto

    Options: 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: Auto

    Options: 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: Iso

    Options: 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 & left

    Options: 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.