Overview
Version
| FineBI Version | Functional Change |
|---|---|
6.0 | / |
Application Scenario
A multi-series line chart is used to display the changes of different indicators within the same dimension over time or other independent variables by drawing multiple lines in the same coordinate system.
For example, you can use a multi-series line chart to display the global energy consumption from 1800 to 2017. The different colored lines in the chart represent various types of energy (such as cement, coal, flaring, gas, and oil), as shown in the following figure.
Basic Requirement
The following table shows the basic requirements for a multi-series line chart.
| Chart Effect | Dimension Field | Indicator Field |
|---|---|---|
Multi-Series Line Chart | > = 1 | > = 2 |
Chart Feature
1. Advantage
Comparison of different series: A multi-series chart allows you to compare multiple data series in the same chart, making it intuitive and easy to compare trends, patterns, and relationships between different series.
Space conservation: By displaying multiple series in the same chart, you can save space and create fewer separate charts, making the report or display more concise.
2. Disadvantage
Visual clutter: Too many series in a chart may lead to visual clutter, making it difficult to distinguish between lines, especially when the colors or styles of these series are similar.
Difficult to display non-numeric relationships: A multi-series line chart is most suitable for displaying numeric data that changes over time or in an ordered category. For non-numeric data or non-linear relationships between data, the multi-series line chart may not be your best choice.
Example One: Creating a Multi-Series Line Chart by Dragging Multiple Fields into the Vertical Axis
Data Preparation
1. Log in to FineBI, click My Analysis, select a folder, and click New Subject, as shown in the following figure.
2. Choose Local Excel > Upload Data, as shown in the following figure.
Sample data: CO2-by-source.xlsx
3. Click OK after the data is uploaded, as shown in the following figure.
4. Click the # button next to the Year field in the column header, and select Text to set the field format to the text format, as shown in the following figure.
5. Click Save and Update to complete the data creation, as shown in the following figure.
Component Creation
1. Click Component in the lower left corner, as shown in the following figure.
2. Select Multi-Series Column Chart in Chart Type.
3. Drag Year from the left to-be-analyzed area to the horizontal axis of the analysis area, and drag Cement, Coal, Flaring, Gas, and Oil to the vertical axis, as shown in the following figure.
Component Beautification
1. Setting the Color
Drag Indicator Name from the left to-be-analyzed area to the Color bar under Graphic Property > All. In this way, different indicators will be displayed in different colors, as shown in the following figure.
2. Setting Indicator Fields on the Vertical Axis
Select Value Format from the drop-down list of Cement on the vertical axis, set Quantity Unit to Million in the setting pop-up box, and click OK, as shown in the following figure.
Select Set Value Axis (Left-value Axis) from the drop-down list of Cement on the vertical axis, set Display Range to Custom in the setting pop-up box, click the blue formula setting icon next to the Min Value bar, and enter 0. Deselect Display Axis Title and click OK, as shown in the following figure.
Creating a Dashboard
1. Click the Add Dashboard button at the bottom of the editing page of the analysis subject.
2. Drag the component into the dashboard on the dashboard editing page, as shown in the following figure.
3. Select Edit Title from the drop-down list, set Font Style to Custom, set the title to Multi-Series Line Chart One, and click OK, as shown in the following figure.
Effect Display
1. PC Terminal
2. Mobile Terminal
Example Two: Creating a Multi-Series Line Chart by Dragging a Field into the Vertical Axis
Data Preparation
1. Log in to FineBI, click My Analysis, select a folder, and click New Subject, as shown in the following figure.
2. Choose Local Excel > Upload Data, as shown in the following figure.
Sample data: Fruit Sales.xlsx
3. Click OK after the data is uploaded, as shown in the following figure.
4. Click the # button next to Year in the header, and select Text to set the field format to the text format, as shown in the following figure.
5. Click Save and Updateto complete the data creation, as shown in the following figure.
Component Creation
1. Click Component in the lower left corner, as shown in the following figure.
2. Select Multi-Series Column Chart in Chart Type.
3. Drag Year from the left to-be-analyzed area to the horizontal axis of the analysis area, and drag Sales to the vertical axis, as shown in the following figure.
4. Drag Classification from the left to-be-analyzed area to the Color bar in the Graphic Property area to generate a multi-series line chart. The lines of different colors represent the sales of different types of fruits, as shown in the following figure.
Creating a Dashboard
1. Click the Add Dashboard button at the bottom of the editing page of the analysis subject.
2. Drag the component into the dashboard on the dashboard editing page, as shown in the following figure.
3. Select Edit Title from the drop-down list, set Font Style to Custom, set the title to Multi-Series Line Chart Two, and click OK, as shown in the following figure.
Effect Display
1. PC Terminal
2. Mobile Terminal
