Column Chart - Area Chart

Version

Application Scenario

After column charts and area charts, two common types of charts are combined, the system can not only compare data by column charts, but also emphasize the cumulative effect and changing trend of data amount by area charts.

For example, you can combine column charts and area charts to show the data, cumulative effect, and change trends of contract amount and payment amount in different provinces, as shown in the following figure.

Implementation Method

When you drag multiple indicator fields into the vertical axis in Custom Chart, the chart type can be set separately for each indicator. You can set the shape to Area for one indicator field, and Column for the other, as shown in the following figure.

Note:

1. The graphic properties set in All apply to all indicators, while those set for an individual indicator only apply to that indicator.

2. For details about graphic property setting, see Graphic Property

Basic Requirement

Chart Feature

1. Advantage

• Rich information: Data specified by different indicators can be displayed together to provide decision-makers with more insights.

• Space-saving: More report space is freed up to display other data.

2. Disadvantage

• Data congestion: Too much data specified by multiple indicators in a combination chart makes the chart too congested.

• Information redundancy: The more the indicators are, the less able the decision-makers are to grasp the main information conveyed by the data.

Data Preparation

Log in to FineBI, click My Analysis, select a folder, and click New Subject, as shown in the following figure.

Click Local Excel, and click Upload Data to upload the sample data, as shown in the following figure.

Sample data:Regional Data Analysis.xlsx

After the data is uploaded, click OK, as shown in the following figure.

Click Save and Update to complete the data preparation, as shown in the following figure.

Component Creation

Click Component in the lower left corner.

Select Custom Chart in Chart Type.

Drag Province from the left to-be-analyzed area into the horizontal axis of the analysis area, and drag Contract Amount and Payback Amount into the vertical axis, as shown in the following figure.

Choose Graphic Property > Contract Amount, and set the shape to Area for Contract Amount. The Column Chart - Area Chart component is successfully created, as shown in the following figure.

Note:

You can only change the setting of the shape under Graphic Property in Custom Chart.

Color Setting

Drag Indicator Name from the left to-be-analyzed area into the Color bar under Graphic Property > All. Different indicators will be displayed in different colors, as shown in the following figure.

Dashboard Creation

Click the Add Dashboard button at the bottom of the editing page in the analysis subject.

Drag the component into the dashboard on the dashboard editing page, as shown in the following figure.

Select Edit Title from the drop-down list, set Font Style to Custom, enter the title as Column Chart - Area Chart, and click OK, as shown in the following figure.

Effect Display

PC

Mobile Terminal