反馈已提交

网络繁忙

You are viewing 5.1 help doc. More details are displayed in the latest help doc.

How to choose the right chart

  • Recent Updates: April 26, 2022
  • 1. Overview

    There are many types of charts. Then how to choose the right chart to achieve the effect of "a picture is worth a thousand words"?

    This article divides the charts into several major categories, namely "Comparison class, Proportion class, Trend or correlation class, Distribution class, and others". Users can choose the appropriate chart according to their own purposes.

    Purpose of using chartSuitable chart type
    CompareColumn chart, contrast column chart, group column chart, stacked column chart, partitioned line chart, radar chart, word cloud, aggregate bubble chart, rose chart
    ProportionPie chart, rectangular tree, percentage stacked column chart, multi-layer pie chart, dashboard
    TrendLine chart, range area chart, area chart, scatter chart, waterfall chart
    DistributedScatter chart, map, thermal map, funnel chart

    2. Comparison class

    2.1 Normal column chart

    Introduction: Normal column chart use vertical bars to display numerical comparisons between categories. One axis of the chart shows the category being compared, and the other axis represents the corresponding scale value.

    Features: It is not suitable for comparing data with more than 10 categories, and it is recommended to use a bar graph when the classification label is too long.

    Examples of scenarios:

    Comparison of sales volume of five products.

    1.png

    2.2 Compare the bar chart

    Introduction: The Contrast Column Chart uses forward and reverse columns to show numerical comparisons between categories. One axis of the chart shows the category being compared, and the other axis represents the corresponding scale value.

    Features: It is used to show the comparison of data with opposite meanings. If it is not the opposite meaning, it is recommended to use group column charts.

    Examples of scenarios:

    A comparison of the votes obtained by the "Democrat" and "Republican" in the U.S. general elections in each state.

    13.png

    2.3 Group column chart

    Introduction: Group column chart is often used to compare different types of data under the same group. Use column height to display numerical comparison, and use color to distinguish different types of data.

    Features: Under the same grouping, there can be no too many categories of data.

    Examples of scenarios: Compare the monthly sales of drinks, necessities and snacks in the first quarter of 2018. Click to view effect: group column chart.

    2.png

    2.4 Stacked column chart

    Introduction: Stacked column chart can compare the total number of groups, and you can also view the size and proportion of each small category contained in each group, so it is very suitable for dealing with the relationship between part and the whole.

    Features: Suitable for displaying the total size, but not suitable for comparing the same category under different groups.

    Examples of scenarios:

    Compare the number of visits from Monday to Sunday, and show the number and approximate proportion of users from which channels visit each day.

    3.png

    2.5 Partitioned line chart

    Introduction: Partitioned line chart is able to separate multiple indicators to reflect the changing trend of things over time or orderly categories.

    Features: It is suitable for comparing trends, and can avoid multiple line chart crossing together.

    Examples of scenarios:

    Compare the wind speed trends of the two cities over the same period of time.

    4.png

    2.6 Radar chart

    Introduction: Radar chart is also called a spidergram. Each of its variables has an axis that emits from the center to the outside. The angles between all the axes are equal, and each axis has the same scale.

    Features: Too many variables in the radar chart will reduce the readability of the chart, which is very suitable for displaying performance data.

    Examples of scenarios:

    Compare the performance of two mobile phones on the market. Click to view effect: Line radar chart.

    5.png

    2.7 Word Cloud

    Introduction: Word cloud is an important way to visualize text big data. It is often used to highlight high-frequency sentences and vocabulary in a large amount of text to quickly perceive the most prominent text. It is often used for statistics of high-frequency search fields on websites.

    Features: It is not suitable for text data with a large amount of data, nor for data processing with little data distinction.

    Examples of scenarios:

    Use word cloud to display automobile brand. The more sales, the larger the font of the keyword.

    12.png

    2.8 Aggregate bubble chart

    Introduction: In the aggregate bubble chart, dimensions define each bubble and measure defines the size and color of bubble.

    Features: It is not suitable for data with little distinction.

    Examples of scenarios:

    An aggregate bubble chart is used to show sales volume of different products. Milk that has the largest sales volume has the largest bubble area.

    9.png

    2.9 Nightingale Rose Chart

    Introduction:  The function of the Nightingale rose chart is similar to that of the column chart. It is mainly used for comparison. The value is mapped to the radius of the rose chart.

    Features: When the data is relatively similar, it is not suitable to use a pie chart, but a Nightingale rose chart.

    Examples of scenarios:

    The size of the repayment amount is mapped to the arc and radius of each province, and finally a rose diagram is formed.

    6.png

    3. Proportion class

    3.1 Pie chart

    Introduction: The pie chart generally distinguishes the categories by color, compares the magnitude of the data. It can show the proportion relationship between each category and the whole.

    Features: The number of categories cannot be too many, and it is not suitable for data with little distinction.

    Examples of scenarios:

    3 (1).png

    3.2 Rectangular tree

    Introduction: Rectangular tree is suitable for displaying data with hierarchical relationships, and it can intuitively reflect the comparison between the same level. Parent nodes nest child nodes and each node is divided into rectangles of different sizes. The size of the area is used to display the corresponding attributes of the node.

    Features: It is very suitable for weighted tree data, comparing the size relationship of each category and the proportion relationship relative to the whole.

    Examples of scenarios:

    Shows the contract amount from 2011 to 2017, with the largest contract amount in 2016. Click to view the effect: Rectangular tree.

    7.png

    3.3 Percentage stacked column chart

    Introduction: The percentage stacked column chart compares the proportions of different categories in the same grouped data.

    Features: The number of different categories in the same group cannot be too many.

    Examples of scenarios:

    The products produced by the production lines have various grades. The proportion of product grades of each production line is shown in the figure below:

    15.png

    3.4 Multi-layer pie chart

    Introduction: Multi-layer pie chart refers to a pie chart with multiple levels and containment relationships between the levels. Multi-layer pie chart is suitable for displaying complex tree structure data with parent-child relationship, such as geographic area data, company upper and lower levels, quarterly, monthly and time levels, etc.

    Features: There should not be too many levels and categories, otherwise the slices will be too small and interfere with reading.

    Examples of scenarios:

    The radians of different colors of the inner ring respectively map the sales of each region, and the light color cut of the outer ring represents the sales of different brands in the region.

    8.png

    3.5 Dashboard

    Introduction: The dashboard sets the target value, which is used to display speed, temperature, progress, completion rate, satisfaction, etc. In many cases it is also used to indicate the proportion.

    Features: It is only suitable for data display of a single indicator.

    Examples of scenarios:

    14.png

    4. Trend or correlation class

    4.1 Line chart

    Introduction: The line chart is very convenient to reflect the trend of things changing over time or other ordered categories. 1) It can analyze the interaction and interaction of multiple groups of data over time, so as to summarize and obtain some conclusions and experience. 2) It can compare the size of multiple groups of data at the same time

    Features: The number of lines should not be too large, otherwise the readability of the chart will become poor.

    Examples of scenarios:

    9 (1).png

    4.2 Range area chart

    Introduction: The range area chart is used to display continuous data, and it can well represent trends, accumulation, reduction, and changes.

    Features: It can show the trend of the difference between two continuous variables.

    Example scenario:

    The following figure shows the change trend of the number of visits and the number of bounces. And the change trend of the difference between the two (non-bounces) is mapped through the change of area.

    8 (1).png

    4.3 Normal area chart

    Introduction: Normal area chart is evolved on the basis of line chart, and it is also convenient to reflect the changing trend of things with time or other ordered categories. Due to the area filling, it can better reflect the trend change than the line chart.

    Features: It is better not to exceed five area lines.

    Example scenario:

    Two area lines are used to indicate the "Contract amount" and "Collection amount". It only shows the trend from 2011 to 2017, but also shows the proportion of the collection amount to the contract amount.

    10.png

    4.4 Scatter chart

    Introduction: Scatter chart can display the shape of data clusters and analyze the distribution of data. By observing the distribution of scattered points, the correlation of variables can be inferred, which can be done by data fitting in FineBI.

    Features: The scatter chart can better reflect the data distribution when there are more data.

    Examples of scenarios:

    After the scatter chart is completed, the correlation of the data can be analyzed by fitting. As can be seen from the figure below, there is a positive correlation between height and weight, but the correlation is not very strong.

    11.png

    4.5 Waterfall chart

    Introduction: The waterfall chart displays the cumulative summary when a value is added or subtracted. It is usually used to analyze the impact of a series of positive and negative values on the initial value (for example, net income).

    Features: Through the floating column chart, the increase and decrease of data can be displayed more intuitively.

    Example scenario:

    14 (1).png

    5. Distribution class

    5.1 Scatter chart

    Introduction : Scatter chart can display the shape of data clusters and analyze the distribution of data. By observing the distribution of scattered points, the correlation of variables can be inferred.

    Features : The scatter chart can better reflect the data distribution when there are more data.

    Examples of scenarios:

    For example, using scatter plots and warning lines, it can be seen that most of the men whose height and weight are above average are males.

    12 (1).png

    5.2 Thermal map

    Introduction: The thermal map  displays the weight of each point in the coordinate range in a special highlight way.

    Features: The effect is softened, and it is not suitable for accurate data expression. And it is mainly used to see the distribution.

    Examples of scenarios:

    Show the temperature distribution for 24 hours a month.

    10 (1).png

    5.3 Map

    Introduction: Even if the map component reflects the data on the geographical location, FineBI provides a variety of map components, including thermal map, regional map, flow direction map, point map, etc

    Features: Observe data relationships in different areas very intuitively.

    Example scenario:

    4 (1).png

    5.4 Funnel chart

    Introduction: Funnel chart, also known as inverted triangle chart, has a logical sequence from top to bottom. It is often used for process analysis, such as analyzing which link has abnormal loss rate.

    Features: There must be a logical sequence relationship between the upper and lower sides. If there is no logical relationship, it is recommended to use a column chart for comparison.

    Examples of scenarios:

    13 (1).png

    Attachment List


    Theme: Build Charts and Analyze data
    Already the First
    Already the Last
    • Helpful
    • Not helpful
    • Only read

    售前咨询电话

    400-811-8890转1

    在线技术支持

    在线QQ:800049425

    热线电话:400-811-8890转2

    总裁办24H投诉

    热线电话:173-1278-1526

    文 档反 馈

    鼠标选中内容,快速反馈问题

    鼠标选中存在疑惑的内容,即可快速反馈问题,我们将会跟进处理。

    不再提示

    10s后关闭