Bubble Chart

A Bubble chart visualizes data set in three of four dimensions where the first two dimensions are used as coordinates like X-Axis and Y-Axis. There remaining two are used to represent the color and size of the bubbles. It is used mostly to Plot financial data.

Best Situation to use Bubble Chart

Three Data Series

If the data has three series each containing values, then the user can use a Bubble chart for better representation. Generally, the sizes of the Bubble are determined by the values.

Default Chart Image

Properties of the Bubble Chart

Alerts

The user can enable the color bands it will show the Range Band color according to the range given in the Band properties.

Axis Setup

The user can Enable the Auto axis, the Base Zero value, Horizontal & Vertical marker line, zero marker line and can change the color of lines, increase and decrease the color Transparency by opacity.

Background

The user can change the background color of the chart, can get the border for the chart and can change the border color, can get the reflection of the chart by enabling the shadow option can also change the color and increase & decrease the transparency of the shadow.

Export Options

The user can enable the “Enable Context Menu”, then it is possible to download the reports in different formats if we click on the chart from the preview section. The heading and subheading of that downloaded chart and the name of the downloaded file can be changed from this section.

Formatter

The user can change Y-axis values in units to %, T, Lacs, M, etc. Precision if we want the value in decimal format. Currency if we want the value in INR, Pound, USD. Position of the currency if it's in prefix and currency in Rupee then the sign will be seen in left-side if it's in suffix then it will be seen in right-side. Number Formatter if we want it in Indian or international.

General

The user can change the height, width, top, left, chart type, column type & Line form. In this case, we have changed the Base type to Gradient.

Legend

The user can enable the internal legend if we want to show and can change the font size, color, style, etc.

Range Indicators

The user can give the Range color for the bubble by selecting the range color in properties and also, we can enable the range legend and can give the solid colors.

Subtitle

The user can enable the subtitle if we have any second title and also, we can change the Name, Font color, size, style, etc.

Title

The user can change Title Name, Font color, size, style, etc.

Tooltip

The user who wants to show the description of the series can use the tooltip by enabling it.

X-Axis

The user changed the axis name, Font color, Font size, Enable the axis line, and changed the axis color.

Y-Axis

The user changed the axis name, Font color, Font size, Enable the axis line, and changed the axis color.

Dataset Series properties

The user can change the color of each series by selecting any of the series and also, we can Enable the Data Label which shows the Value of each Revenue & Expenses.

Default Dataset Properties

Data used

The following data was used to generate the given example:

  • Use the Year column as Category field and the other columns as Series to plot data as shown in the given example below:

Year
Expense
Revenue

1

48

50

2

41

43

3

60

54

4

78

56

5

70

56

6

43

45

7

53

56

8

45

47

9

57

62

10

40

34

11

78

87

12

57

65

13

45

45

14

38

35

15

58

60

16

78

75

17

55

56

Please Note: The Category field can be any data type line, string, or numeric. But, Series fields can be only numeric data type.

Various Variants of the Bubble chart

It is possible to get the following variants of the Bubble chart by changing the Properties:

Bubble Chart with Gradient Base

Bubble Chart with Plain Base

Bubble Chart with Ring Base

Last updated