An area chart, also known as a region chart, plots data arranged in rows or columns of a worksheet as points on the chart, connects them with straight lines, and displays them as a filled area. An area chart is similar to a line chart, but differs in that it fills the space between the line and the X-axis with color. It is suitable for illustrating data trends and the contribution of parts to the whole. The product provides area charts and percentage area charts.

2.1 Common usage scenarios #

An area chart emphasizes the degree of change in values over time or across categories. It can also show the trend of parts within the whole, drawing attention to the overall trend. For example, the change in sales amounts across regions over time.
Area chart example

Percentage area chart example

2.2 Usage process example #

Step 1: Set dimensions, metrics, and filter conditions
Select [Date] and [Region] as dimensions; [Brand sales volume] as the metric.

Step 2: Select area chart from the chart panel

Step 3: Modify the chart format as needed

3.1 Area chart icon #

Click the triangle under area chart to switch between "Area chart" and "Percentage area chart".

3.2 Configuration rules #

Both support plotting after setting one or more dimensions and one or more metrics. Generally, there are no more than two metrics.

3.2.1 Area chart #

Dimension: Supports one or more dimensions. If there is more than one dimension, the second and subsequent dimensions are displayed in a stacked manner, distinguished by different colors.
Metric: Supports one or more metrics, typically one metric. If there is more than one metric, the second and subsequent metrics are displayed in a stacked manner, distinguished by different colors.
Example 1: One dimension, one metric

Example 2: Two dimensions, one metric

3.2.2 Percentage area chart #

Dimension: Supports one or more dimensions, typically multiple dimensions. If there is more than one dimension, the second and subsequent dimensions will be stacked on the bars and distinguished by different colors.
Metric: Supports one or more metrics, typically one metric. If there is more than one metric, the second and subsequent metrics will be displayed in a stacked manner and distinguished by different colors.
Percentage display: The sum of the area stacks for the first dimension is 100%.
Example 1: One dimension, two metrics

Example 2: Two dimensions, one metric

3.3 In-chart control styles #

In-chart controls include: filters, dynamic dimensions/metrics, and in-chart parameters. You can configure the styles.
For example: arrange the title of the dynamic metric control style vertically; set the layout to a balanced position.

3.4 Edit colors #

You can set corresponding colors for the area chart. Multiple color schemes are built into the product.

It also supports Custom Color Schemes

3.5 Line styles #

Scope of effect: You can set different display styles for a specified data series.

Line type: You can choose between straight line or smooth line, line thickness, as well as solid, dashed, or dotted lines.
Marker: You can choose no marker, hollow circle, solid circle, square, diamond, and select the marker size.

3.6 X-axis/Y-axis #

See 3.5 X-axis/Y-axis.

3.7 Grid lines #

See 3.6 Grid lines.

3.8 Special values #

See 3.7 Special values.

3.9 Legend and labels #

Legend:

• You can click the switch button on the right to choose whether to display legend information.
• You can set the legend position in the chart: top, bottom, left, or right.
• You can set the legend alignment: align to top/left, center, or bottom/right.
• You can set the maximum number of legend columns, as well as the font and color.
• You can set the legend display mode. When there are too many legends, you can choose between pagination or a scrollbar for display.
  

Label:
See 3.8 Legends and labels.

3.10 Tooltip #

See 3.9 Tooltips information.

3.11 Display mode #

See 3.10 Display mode.

3.12 Restore default settings #

Click [Restore Default Settings] to revert all the above chart configurations to their default values.

3.13 Pivot #

See Pivot Chart.