Report analysis tool making bubble chart

Tools/Materials

• Report analysis Tools : FineReport7.1.1

• Size: 148.2M applicable platform: windows/linux

1. Overview

A bubble chart is a variant of a scatter chart, in which the scatter plot uses a group of x, y values (two dimensions), and the bubble chart uses a group of x, Y, Z values (three-dimensional) whose z-values determine the size of the bubbles.

The following bubble chart to monitor the price of each condiment, cost and Inventory order difference:

650) this.width=650; "src=" Http://www.finereporthelp.com/help/11/0/3-1.png "style=" padding:10px 0px 5px; "alt=" 3-1. PNG "/>

2. Example

2.1 Data Preparation

Create a new workbook, add a dataset Ds1,sql statement for Select Product name, cost price, Unit price, (stock-order Amount) as Inventory order variance from product where category ID = 2;

Find out the cost of each condiment, unit price, inventory and order amount of difference, to make a bubble chart monitoring condiment three dimensions of the value, where the difference between inventory and order quantity to determine the bubble size.

2.2 Inserting a chart

Take the hover chart as an example, click Insert > Hover element > Insert Chart , select Bubble chart, click OK.

2.3 Chart Data settings

The chart data is derived from the dataset data , and the bubble chart is fixed with 3 series, representing the x-axis, y-axis, and bubble size, such as:

650) this.width=650; "src=" Http://www.finereporthelp.com/help/11/0/3-2.png "style=" padding:10px 0px 5px; "alt=" 3-2. PNG "/>

Click Done and the page break preview looks like this:

650) this.width=650; "src=" Http://www.finereporthelp.com/help/11/0/3-3.png "style=" padding:10px 0px 5px; "alt=" 3-3. PNG "/>

Can see, the default bubble chart is not beautiful, see what each bubble represents, some bubbles too underestimated unclear and so on. We can adjust the series style of bubbles to achieve a beautiful bubble chart.

2.4 Bubble Chart Series settings

Check the bubble chart, click the Chart property sheet-styles > Series , such as:

650) this.width=650; "src=" Http://www.finereporthelp.com/help/11/0/3-4.png "style=" padding:10px 0px 5px; "alt=" 3-4. PNG "/>

• Size representation

That is, the size of the bubble chart meaning, divided into two kinds, area or width, the calculated units are pixels.

The principle is to set the bubble size to 50, the maximum bubble radius in the entire bubble chart is 50 pixels, and then depending on the size of the selection, such as selecting the bubble area , the size of the other bubbles is adjusted according to the area of the bubble.

• Show

Show negative bubbles: If the series 3 (Z axis) has negative values, check this option negative bubbles will appear dimmed, if not checked this option will not show negative bubbles, as shown above, the chili powder, tomato sauce and meat floss are gray, that is, negative.

• Other series settings

Other series settings are the same as other chart settings, such as displaying labels, adding a cordon, and so on.

2.5 Saving and previewing

Save the template and click the page break preview to see the effect. Template effect Online view please click Bubble.cpt

The full template can be referenced %fr_home%\webreport\web-inf\reportlets\doc\advanced\chart\bubble.cpt.

Report analysis tool making bubble chart