Bubble Chart

Version

Application Scenario

The bubble charts represent the size or volume of the data by the size of the bubbles and represent the category or group of the data by the color of the bubbles. The chart is suitable for displaying multiple groups of data, allowing for a visual comparison of the values between different categories.

In a bubble chart, each bubble represents a data point. The position of the bubble is usually determined by two axes (similar to a scatter chart) while the size of the bubble represents the size of the value it associates. In addition, different data categories or groups can be distinguished by different colored bubbles.

For example, you can use a bubble chart to display the actual enrollment of different provinces. You can visually find out that Jiangsu, Shanghai, and Shanxi rank the top three in terms of the actual enrollment based on the following figure.

Basic Requirement

The basic requirements for bubble charts are as follows.

Chart Feature

1. Advantage

• Visual comparison: You can visually compare the values of different categories or groups through the size of the bubbles.

• Data distribution observation: The bubble charts can be used to observe the distribution of data, representing the data by the size of the bubbles, which helps identify patterns or outliers in the dataset.

2. Disadvantage

• Data volume limit: Too many bubbles in the dataset can make the chart cluttered and difficult to understand, especially when the bubbles overlap.

• Visual perception error: As the chart displays the three-dimensional data by a two-dimensional plane, a certain visual perception error exists, which may affect the accurate judgment of data size.

Data Preparation

1. Log in to FineBI, click My Analysis, select a folder, and click New Subject, as shown in the following figure.

2. Choose Local Excel > Upload Data, as shown in the following figure.

Sample data:Enrollment by Province.xlsx

3. Click OK after the data is uploaded, as shown in the following figure.

4. Click Save and Update to complete the data preparation, as shown in the following figure.

Component Creation

1. Click Component in the lower left corner.

2. Select Bubble Chart in Chart Type.

3. Drag the Province field from the left to-be-analyzed area into the Color bar under Graphic Property, and drag the Actual Enrollment field into the Size bar, as shown in the following figure.

Chart Beautification

Legend Setting

Choose Component Style > Legend and deselect Display All Legends, as shown in the following figure.

Comment Setting

1. Click the drop-down icon of the Actual Enrollment field in the Size bar under Graphic Property, and choose Special Display > Comment ..., as shown in the following figure.

2. Click Add > Add Condition in the pop-up settings box, and filter the top 3 with the highest actual enrollment. Click the add icon on the right side of the text display area, select Province in the drop-down list, and click OK, as shown in the following figure.

Dashboard Creation

1. Click the Add Dashboard button at the bottom of the editing page of the analysis subject.

2. Drag the component into the dashboard on the dashboard editing page, as shown in the following figure.

3. Select Edit Title from the drop-down list, set Font Style to Custom, enter the title as Bubble Chart, and click OK, as shown in the following figure.

Effect Display

PC

Mobile Terminal