Column Chart

Version

Application Scenario

The column chart displays data sizes through the height or length of columns with the same width. The column chart displays and compares data sizes, and shows the proportional difference between data clearly, as shown in the following figure.

Chart Feature

Advantage: The column shows the data sizes by the lengths of the columns, making it easier for you to compare the differences among various groups of data.

Disadvantage: The chart is unsuitable for large datasets.

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.

Chart Insertion

Merge required cells, click the Insert Chart icon on the upper toolbar, and select Column Chart, as shown in the following figure.

Column 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.

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

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

1. Choose Style > Title, and enter Sales Per Salesperson.

2. Choose Style > Label, select Use Label, select Value in Text, and select Custom for Character.

3. Choose Style > Series, set Color Scheme to Custom Combination, and set Line Style in the Border setting area to None. For details about setting the series of the column chart, see Chart Series.

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 preview effect.

Problem

During the design of a chart, you may find that the column is not displayed in the center, as shown in the following figure.

Cause

This is because you select Region for Category and Series at the same time, which results in different series among different categories. If a series does not exist in one of the categories, a blank position will be generated in the chart.

Solution

In this case, set Series to None, or select Field Name, and set Field Name to Sales_Volume.

However, for the column chart or the pie chart, when the series of different categories differ from each other, blank placeholders will occur. This is the feature of the charts. So, bind the data as shown in the following figure.

If the fields selected for Category and Series are different, the blank placeholders caused by series differences cannot be removed.

For details, you can download the template Basic Column Chart.cpt.