Area Chart - Line Chart

Version

Application Scenario

After area charts and line charts, two common types of charts are combined, the system can display not only the accumulation effect and changing trend of data amount by area charts, but also the changing trend of data by line charts.

For example, you can combine area charts and line charts to compare the planned and actual production costs for more easily checking whether the cost consumption is abnormal, 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 Line 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:Production Cost.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 Year-Month from the left to-be-analyzed area to the horizontal axis of the analysis area, and drag Planned Production Cost and Actual Production Cost to the vertical axis, as shown in the following figure.

Choose Graphic Property > Planned Production Cost, and set the shape to Area, as shown in the following figure.

Choose Graphic Property > Actual Production Cost, and set the shape to Line, as shown in the following figure.

Component Beautification

Style Adjustment

Click the setting icon next to Connection under Graphic Property > Planned Production Cost, and set Style to Curve, as shown in the following figure.

Similarly, set the Style to Curve for Actual Production Cost, as shown in the following figure.

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, set the title to Area Chart -Line Chart, and click OK, as shown in the following figure.

Effect Display

PC

Mobile Terminal