Rose Chart

Version

Application Scenario

Displaying values by the radii and areas of sectors, rose charts are generally used for the proportion analysis of two-dimensional data with numerous records and similar sizes.

Two types of rose charts are available in FineReport:

• Rose Chart (Equal Radians): Each sector has the same radian, while has the radius and area changed with the value.

• Rose Chart (Unequal Radians): Each sector has its radian, radius, and area changed with the value.

The following figure shows the effect.

Chart Feature

Advantage: Rose charts can intuitively compare the value differences among various series, which is visually pleasing.

Disadvantage: Since the radius and area are in a square relationship, the proportion of data will be exaggerated in rose charts. As a result, rose charts are unsuitable for analyzing data with overly large differences.

Data Preparation

Choose File > New General Report in the upper left of the designer, click xxx, click Database Query, and enter the SQL statement SELECT Salesperson,sum(Sales_Volume) as Sales FROM Sales_Volume group by Salesperson order by Sales_Volume to create a database query ds1. Through this statement, total sales are extracted by salespersons and sales from the sales table and sorted by sales in the ascending order.

Chart Insertion

Merge required cells, click the Insert Chart icon on the upper toolbar, and choose Pie Chart > Rose Chart (Equal Radians), as shown in the following figure. 

Chart Design

Select the chart, click the Cell Element icon on the right property panel, and set the properties (Type, Data, Style, and Special Effect) for the chart.

Chart Type

Select the cell where the chart is located and choose Cell Element > Type to view and select the chart type.

Data Binding

Click Data and bind required data to the chart, as shown in the following figure.

Style Setting

1. Choose Style > Title, enter Rose Chart (Equal Radians), and retain the default settings of other items, as shown in the following figure.

2. Choose Style > Series, set Gradient Style to Off and Color Scheme to Custom Gradient Color, click the color bar, and set the left color value to ff6666 and the right to 0cd387 in the color pop-up box. Finally, select None from the drop-down list of Line Style in Border, as shown in the following figure.

Chart Copying and Pasting

After Rose Chart (Equal Radians) is designed completely by the above-mentioned steps, copy and paste Rose Chart (Equal Radians), and modify Rose Chart (Equal Radians) to create Rose Chart (Unequal Radians).

1. After copying and pasting Rose Chart (Equal Radians), click the Cell Element icon, select Type, and select Rose Chart (Unequal Radians) for Pie Chart, as shown in the following figure. 

2. Modify the chart title, as shown in the following figure.

3. Modify the series style. In this example, set Start Angle to 270 and End Angle to 90 (forming the shape of a semicircle) for Rose Chart (Unequal Radians), and set Core to 10% (hollowing out the chart), as shown in the following figure.

Effect Display

PC

Save the report and click Pagination Preview. The following figure shows the preview effect.

Mobile Terminal

The report can be previewed on both the DataAnalyst app and the HTML5 terminal. The following figure shows the effect.

For details, you can download the template Rose Chart.cpt.