Bubble Chart

Introduction

Description

Bubble charts can be used to show the relationship between three variables. Like scatter charts, bubble charts are represented on X-axis (the first variable), Y-axis (the second variable), and the size of the bubble (the third variable).

Application Scenarios

By bubble charts, you can have a clear understanding of the relationship between values of data series, similar to the function of X-axis and Y-axis, which can help you to determine whether there is one kind of association between two variables, or to discover the distribution or aggregation of data.

Requirements

The number of measures and dimensions are:

Preview

A bubble chart of Product Sales and Profitability is shown in the figure below:

Plan Description

This is an advanced function that requires the Standard or above plans. For details, see Jodoo Pricing.

Setting Procedure

Preparing Data Sources

1. Create a form

Visit an app, click New > New Form, and select Create from Excel.

2. Import the sample data

Then import the prepared data.

3. Adjust field types

When importing the data, match the field types according to the style below. After matching data, click Import.

Creating a Chart

1. Create a dashboard

Go back to the app page and click New > New Dashboard.

2. Select the data source

Then select Stats for data analysis and select the data source from Product Sales Data. As shown in the figure below:

3. Set and select charts

After creating a chart, rename the chart, select All Form Data under Access and select Bubble Chart under Chart Type. As shown in the figure below:

Setting Dimensions/Measures

Drag and drop measures and dimensions to the position shown in the figure below:

Configuring Settings

Move the mouse to Settings on the right panel for further settings.

1. Set bubbles

The bubble settings consist of two parts, one for the bubble diameter and one for the bubble style.

o The optional fields are related to the measure field type. When the measure is a main field, only the main field can be selected as the diameter.

o When the measure is a sub-field, only the sub-field can be selected as the diameter.

o The default maximum diameter is 60 and the minimum diameter is 12. You can customize other values based on your needs.

o Set whether to display bubble shadow.

o Set whether to display negative bubble data. Notes:

§ The negative bubble diameter is controlled.

§ If diameter is not set, this setting will not take effect.

2. Set Axis

For X-axis and Y-axis, you can set the title to distinguish the data of X-axis and Y-axis.

3. Data labels and legends

Since the bubble chart is composed of multiple unevenly distributed bubbles, if each bubble has to display data labels, it will show messy data. Therefore, you can cancel the label display under the Data Label and only choose to display the dimension value. If you need to set Legend, you can also set whether to display it and to display the position. As shown in the figure below:

For details, see Settings.

Chart Styles

You can set the visual style of the chart by clicking Style > Chart Color. As shown in the figure below:

Click OK to return to the dashboard editing page. As shown in the figure below:

Demonstration

Drag the lower right corner of the chart and you can adjust the chart size for viewing.