Overview
Version
| FineBI Version | Functional Change |
|---|---|
| 6.0 | - |
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 Effect | Dimension Field | Indicator Field |
|---|---|---|
| Area Chart - Line Chart | 1 | 2 |
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.
Procedure
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
