Stacked Column Radar Chart

Version

Application Scenario

With the features of the radar chart and the column chart, the stacked column radar chart is suitable for displaying the cumulative changes of variables over time or by category, and evaluating and comparing the cumulative performances of different entities on multiple performance indicators. The following figure shows the effect.

Chart Feature

Advantages: The chart intuitively displays the cumulative effects of variables over time or by category, which helps you compare the cumulative performances of multiple entities in multiple dimensions.

Disadvantages: The number of variables should not be too large, otherwise the chart will be complicated and difficult to understand. Besides, the difficulty in judging the radial distance may lead to the unintuitive comparison of specific values.

Data Preparation

Create a general report and create a data query named ds1. The SQL statement is as follows:

SELECT Category_Name, Inventory_Quantity, Order_Quantity, Reorder_Quantity FROM Product, Category

WHERE p.CategoryID = c.CategoryID AND Category_Name != 'Daily necessities'

ORDER BY Category_Name.

Chart Insertion

Merge required cells, click the Insert Chart icon on the upper toolbar, and select Stacked Column Radar Chart, 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

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

Style Setting

You need to modify the title of the radar chart. To set the polar axis label not to be displayed, you can choose Style > Axis > Polar Axis, set Axis Label to Hide, and retain the default settings of other items.

Effect Display

PC

Save the report and click Pagination Preview. The section "Application Scenario" shows the 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 Stacked Column Radar Chart.cpt.