I. Intro
Platform requirement: These steps can only be performed on the Lark desktop app.
A bubble chart is a variation of scatter charts, and consists of two axes and bubbles of varying sizes. Bubbles and their position on the chart can represent three variables. The density and size of the bubbles serve as important indicators for predicting trends.
Take the following chart as an example. The bubble chart shows the sales quantity, revenue, and revenue proportion of products of different categories.
- X-axis: Shows the sales quantity.
- Y-axis: Shows the revenue.
- Bubble size: Represents the size of revenue relative to others.
- Bubble label: The text in the bubble, in this case, the product name.
- Bubble color: The series, in this case, the product type.
250px|700px|reset
250px|700px|reset
II. Steps
- Insert a bubble chart
Open the spreadsheet, click Insert from the toolbar, and select Chart. In the chart editor pane that pops up on the right, select the bubble chart.
250px|700px|reset
- Set the theme color and chart options
In Setup > Themes, select the theme color for the chart.
In Setup > Options, select whether the title, legend, data labels, axis, and gridline should be displayed.
250px|700px|reset
- Select the data range
In Setup > Range, click the Grid icon, and enter the data range in the pop-up window, or select it on the sheet. Click Add another range to add more data ranges as needed.
250px|700px|reset
250px|700px|reset
- Set labels, horizontal axis, vertical axis, series, and bubble size
In the data range, the text or date data in the first row or column will be used as the chart's x-axis (category) and y-axis (series). To switch the data on the two axes, click Switch rows/columns.
Click the field under a category to select different data or customize its data range by clicking the Grid icon.
- Label: Data must be number or text format, and appears as text in the bubble. If there is data with the same label, you can select Aggregate to aggregate the data.
- X values: Must be number format.
- Y values: Must be number format.
- Series: Data must be in number or text format. Shows as the color of the bubble.
- Area of bubble size: Must be number format.
250px|700px|reset
250px|700px|reset
250px|700px|reset
- Configure more settings
In Setup > More settings, you can set whether to show hidden and filtered data and negative values.
250px|700px|reset
- Customize chart style
Click the Customize tab to set the background and font, the chart and axis titles, series, legend, horizontal axis, vertical axis, and so on. For more details, see Edit the x-axis and y-axis of charts.
250px|700px|reset
In addition to the default label settings, you can add multiple labels in the bubble by setting the series. Select Show data labels, then add label content as needed, and modify its text format.
250px|700px|reset
250px|700px|reset
You can set the color for each bubble individually using the following methods:
Method 1: In Customize > Series, select the series for which you want to change the color. Click Add data point, select the data point, and then select a color under Data point style.
Method 2: Double-click the bubble in the bubble chart to directly enter the data point style settings pane, and change the color as needed.
250px|700px|reset
250px|700px|reset
- Other actions for bubble charts
- Paste the bubble chart into a document: You can paste the bubble chart into a document and maintain a link with the source Sheets, allowing for real-time data sync. For more details, see Paste Sheets charts into a document.
- Adjust the position and size of the bubble chart: You can select the bubble chart and drag it to adjust its position. You can also hover the mouse over the edge of the bubble chart and drag it to adjust its size.
- Copy, delete, or download the bubble chart: Select the bubble chart and click the Column Chart icon in the upper-right corner where you can edit, copy, or delete the bubble chart, or download it as an image.
250px|700px|reset