Multi-Category Pie Chart

Version

Expected Effect

Both the pie chart and rose chart allow you to generate multiple charts by different categories. The series displayed by each chart are shown in the legend. If the series of the categories differ from each other, all series will be displayed.

Implementation Method

After inserting a pie chart, set the category field, based on which multiple pie charts are generated.

Note: The method also applies to charts of the cell element and floating element.

Data Preparation

Choose File > New General Report, create a database query ds1, and enter the SQL statement SELECT * FROM Sales_Volume, as shown in the following figure.

Template Theme Selection

Click the theme name above the report, and select Refresh Technology in the Template Theme selecting pop-up box, as shown in the following figure.

Chart Insertion

Merge required cells, select the merged cell, click the Insert Chart icon on the upper toolbar, select Pie Chart, and click OK, 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.

Data Binding

Select the chart, choose Cell Element > Data, and bind the data as shown in the following figure. The Region field is bound to Category, which indicates that each region will correspond to a chart.

Style Setting

1. Choose Style > Title, enter Product Sales Per Region, and left-align the title, as shown in the following figure. 

2. The labels are not displayed by default in the chart. You need to set the items under Style > Label, otherwise the multiple categories will not be displayed.

Choose Style > Label, and select Use Label. In this example, the value label is set not to be displayed. Select Category Name and set Position to Bottom in the Category Label setting area.

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 Multi-Category Pie Chart.cpt.