Bar Chart

Version

Application Scenario

The bar chart displays data sizes through the height or length of bars with the same width.

The bar chart displays and compares data sizes, and shows the proportional difference between data clearly, as shown in the following figure.

Chart Feature

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

Disadvantage: The chart is unsuitable for displaying large datasets.

Data Preparation

Choose File > New General Report in the upper left corner of the designer, and create a dataset ds1. The database query statement is as follows:

SELECT Product.Category_name, Inventory_quantity, Order_quantity, Reorder_quantity FROM Product, Category

WHERE Product.CategoryID = Category.CategoryID AND Product.Category_name != 'Daily necessities'

ORDER BY Category_Name.

Chart Insertion

Merge required cells, click the Insert Chart icon on the upper toolbar, and select Bar 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 attributes (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.

Data Binding

1. Select the chart and choose Cell Element > Data on the right property panel.

2. Bind the data in the Dataset. Select ds1 for Dataset, Category_Name for Category, Field Name for Series Name (Inventory_Quantity and Order_Quantity fields), and Sum for Summary.

Style Setting

Select the chart, choose Cell Element > Style > Title, enter Bar Chart in the Text, and set the rest settings by default, as shown in the following figure.

Effect Display

PC

Save the report and click Pagination Preview. The section "Application Scenario" shows the effect.

Mobile Terminal

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

For details, you can click to download the template Bar Chart.cpt.