I. Overview
1) Area Charts are charts that emphasize the extent to which quantities change over time and can draw attention to trends in aggregate values.
2) There are four subtypes of area charts: Area Chart, Stacked Area Chart, Percentage Stacked Area Chart and Custom.
Area Chart: shows the trend line and its area for various values over time or categories.
Stacked Area Chart: the values of variables are stacked in turn as totals, and the difference between the areas of each variable is the actual value. A Stacked Area Chart is suitable for showing changes in the totals, the contributions of each variable, and changes in each variable.
Percentage Stacked Area Chart: the percentages of the values of each variable to the totals are stacked in order, with the upper edges of the area always corresponding to 100%. A Percentage Stacked Area Chart is suitable for showing the percentages of each variable and their changes.
Custom: users can customize the attributes of stacks and axes.
3) Please read: Chart Data, Chart Style, Chart Special Effects
| You will learn |
|---|
|
II. Steps
This article takes a Custom Area Chart as an example. The settings of other subtypes are similar.
1. Prepare Data
Create a new Template Dataset: DB Query named ds1. Select FRDemo for the Data Connection Enter the following query statements.
SELECT * FROM
Product JOIN ProductCategory
ON Product.CategoryID=ProductCategory.CategoryID
WHERE Category_name! ="Daily necessities"
ORDER BY Category_name
2. Insert chart
Take Floating Chart as an example: Refer to Insert Floating Chart:
In the pop-up [Chart Type] panel, select [Area Chart] on the left.
Select [Custom].
Click [OK] to finish inserting the Custom Area Chart.
3. Bind Data
Set data as follows:
Double-click on the chart.
Click [Cell Element] on the right-hand pane. Click [Data].
Select [Dataset data] in [Data source], and [ds1] in [Dataset]
Select [Category_name] for the [Category].
Select Filed Name for the Series Name. Add [Order_quantity] and [Re_order_quantity]. Select [Sum] for the Summary Method.
4. Set style
1) General style
Select the chart and click [Style]. There are a variety of chart types, but most of the style settings are similar to the general style. You can refer to Chart Style and the default setting is as follows:
Change the chart title:
Click [Title].
Change the [Text] of the Title to: Area Chart.
2) Special Style
Some settings in the [Style] of the Area Chart are different from the general style, and are introduced separately here.
Label: Click on [Label] to set the Label of the chart, and find the options under [Layout].
Position: An option [Automation] has been added for the Position. When this option is selected, some labels may change position based on best case scenario.
Overlap Adjust: When multiple labels are overlapped, this function can be activated, and then the system will automatically stagger the position of labels.
Custom Axis: For a Custom Area Chart, you can add an additional X or Y Axis under the [Style]>[Axis], and set the attributes of the new axes. For example, there are two Y axes in the following figure: Y Axis and Y Axis2.
Series - Stack and Axis: For a Custom Area Chart, the newly added axes need to correspond to different series. You can find the [Stack and Axis] under [Style]>[Series] to custom the series corresponding the axes, and whether the series is Stacked or 100% Stacked or not. For example, the Series2 (i.e., Re_order_quantity) corresponds to Y Axis2, and will not be Stacked or 100% Stacked.
5. Set Special Effect
For a detailed description of settings of Special Effect, see Chart Special Effects for the settings of general special effects.
6. Preview Effect
1) Save and preview.
2) You can see that Series1 Order_quantity corresponds to the Y axis on the left, and Series2 Re_order_quantity corresponds to the Y axis on the right.
3) When the mouse hovers over the legend of a series, it will become solid filled with highlights.
