Stacked Column Chart - Line Chart

Application Scenario

The column chart - line chart is a combined chart that combines the stacked column chart where columns of different series are stacked, and the line chart that marks values as points and connects these points in a certain order with straight lines.

The stacked column chart - line chart can intuitively compare the amount of data and the sum, clearly display the proportional differences among the data, and show the trends that change over time or with ordered categories.

As shown in the following figure, the stacked column chart - line chart stacks the order quantities and reorder quantities and compares them with the inventory quantities. If the stacked total order quantity is greater than the inventory quantity, replenishment is needed.

Chart Feature

Advantage: Simple and intuitive, the chart is not only suitable for comparing the differences and sums among data of various groups, but also for datasets where trends are more important than individual data points

Disadvantage: The chart is not suitable for large datasets.

Type

When inserting a chart as a cell element or a floating element, select the stacked column chart - line chart as the chart type, as shown in the following figure.

Data

The stacked column chart - line chart needs to bind the data of the column chart and the line chart respectively. For details about data binding, see Chart Data.

Style

For details about the style design of the stacked column chart - line chart, see Chart Style.

Note: You do not need to set the axes and series of the column chart and the line chart here.

Special Effect

For details about the special effect setting of the stacked column chart - line chart, see Chart Style.

Report Design

Data Preparation

Create datasets ds1 and ds2. The SQL statements for database queries are as follows:

ds1: SELECT Product_name,Order_quantity,Re_order_quantity FROM Product where CategoryID = 1

ds2: SELECT Product_name,Inventory_quantity FROM Product where CategoryID = 1

Chart Insertion

Merge required cells, right-click cell A1, and choose Cell Element > Insert Chart > Combination Chart > Stacked Column Chart - Line Chart, as shown in the following figure.

Data Binding

Bind required data to the stacked column chart and the line chart respectively, as shown in the following figure.

Style Setting

For basic style setting, modify the title of the stacked column chart - line chart, and remain the settings of other items.

Note: For the three types of built-in combination charts, the column chart lies in the lowermost layer, while the line chart lies in the uppermost layer.

Effect Display

PC

Save the template, and click Pagination Preview. The following figure shows the effect.

Mobile Terminal

For details, you can download the template Stacked Column Chart - Line Chart.cpt.