Custom Combination Chart

Version

Application Scenario

When you select Custom Combination in Combination Chart, you can flexibly select charts from fifteen types of charts including column charts, line charts, area charts, and pie charts for chart combination, as shown in the following figure. 

Custom combination charts are suitable when you need to compare data across multiple categories from multiple datasets at the same time. For example, you can combine a pie chart and a column chart. The following figure shows the expected effect.

Chart Feature

• Through custom combination charts, you can combine appropriate charts more flexibly to integrate the advantages of each chart.

• Custom combination charts are suitable for clearly comparing the proportions of data across different categories from different datasets.

Take Column Chart - Pie Chart as an example. The following introduces the operation steps.

Data Preparation

Choose File > New General Report in the upper left of the designer, and select Refresh Technology as the template theme.

2. Create a database query ds1 with the SQL query statement SELECT * FROM Sales_Volume, as shown in the following figure.

Chart Insertion

Merge required cells, click the Insert Chart icon on the upper toolbar, and choose Combination Chart > Custom Combination, as shown in the following figure. 

Combination Chart Design

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

Chart Type

Select the cell where the chart is located, right-click the cell, choose Cell Element > Type, and select Column Chart and Pie Chart.

Note: The order in which these two charts are selected determines the order of the layer overlay during chart drawing. The chart selected later will be displayed in the upper layer.

Data Binding

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

Style Setting

1. Set Legend.

Choose Style > Legend, and set Position to Top and Arrangement to Aligned, as shown in the following figure.

2. Set Series.

Choose Style > Series, and set Color Scheme to Custom Combination. The color scheme is effective for both the column chart and the pie chart.

Note: If you want to set an independent color scheme for a certain chart, you need to set the color scheme under Special Effect > Condition Display.

• Column Chart: In this example, the stacked column chart to be made is not available in the selectable chart types of the custom combination chart. Therefore, you need to manually set Stack and Axis, as shown in the following figure.

In this example, add Stack and Axis 1 and Stack and Axis 2. For Stack and Axis 1, add the condition Series Index Equal to '1'or Series Index Equal to '2'or Series Index Equal to '3' to display the data of the first three series, as shown in the following figure.

For Stack and Axis 2, Add the condition Series Index Equal to '4'or Series Index Equal to '5' to display the data of the last two series, as shown in the following figure.

Note: When you set Stack and Axis, the series indexes refer to the series indexes of the data in the currently selected chart rather than those of all the data.

• Pie Chart: You can customize the position of the pie chart by modifying the proportion in X Direction and Y Direction under Location > Position (%). The following figure shows the settings in this example.

3. To avoid overlap between the column chart and the pie chart, set Custom Maximum Value to 4000 under Style > Axis > Y Axis > Value Definition, as shown in the following figure.

4. Choose Style > Label > Pie Chart, select Use Label, select Percentage in Text, set Position to Outside Pie, and click Traction Line, as shown in the following figure.

Effect Display

PC

Save the report and click Pagination Preview. The effect is the same as that shown in section "Application Scenario."

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 Custom Combination Chart.cpt.