Stacked Line Chart

Version

Stacked line charts are suitable for showing the cumulative effect of data in different categories or time periods, and are often used to show the cumulative amount over time or the contribution of different parts to the total, as shown in the following figure. /

Chart Feature

Stacked line charts show multiple data series accumulated over time by colors, reflecting the contribution of each part to the total and its changing trends visually.

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 Insert Chart on the upper toolbar, and choose Line Chart > Stacked Line 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.

Chart Type

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

Data Binding

Binding the data from ds1 to the line chart, as shown in the following figure.

Note:

In data binfding, you canot select None from the drop-down list of Category, and if you select Field Value for Series Name, the series name cannot be the same field as the category. Otherwise, the chart will only display dots without lines.

Style Setting

1. Choose Style > Title and enter Stacked Line Chart in Text. Save the rest of the settings as default, as shown in the following figure. 

2. Choose Style > Legend and tick Show Legend.

3. Choose Style > Series, select Theme from the drop-down list of Color Scheme, and save the rest of the settings as default. For more settings about Series of Line Chart, see Chart Series.

Effect Display

PC

Save the report and click Pagination Preview. The effect is 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 click to download the template Stacked Line Chart.cpt