I. Intro
Platform requirement: These steps can only be performed on the Lark desktop app.
In Sheets, you can insert various chart types like column charts, line charts, and area charts to visualize data, enabling quicker and clearer understanding and analysis of data relationships, trends, and proportions.
II. Chart types
The following charts are supported.
Chart | Style | Purpose | Examples |
Column | 250px|700px|reset | Suitable for comparing different categories of data, especially showing the differences between categories in different time periods or comparing the differences between sub-categories within each category. |
|
Line | 250px|700px|reset | Suitable for displaying changes in data over time. Suitable for situations where seeing trends evolving over time is important. |
|
Pie | 250px|700px|reset | Suitable for evaluating how different parts contribute to the whole. Each slice represents a share of a particular category to the total, with the aggregate of all slices equaling 100%. |
|
Bar | 250px|700px|reset | Similar to a column chart, it is used to compare the differences between different categories or sub-categories of data. Suitable for data that requires long bars. |
|
250px|700px|reset | Using colors below the lines, area charts illustrate the differences between variables, and is often used to highlight changes over time . |
| |
Scatter | 250px|700px|reset | Suitable for finding the correlation between two data sets. Data points are represented as dots on the graph. |
|
| 250px|700px|reset | It can be used to display data in three dimensions, namely the values of the horizontal axis, the values of the vertical axis, and the size of the bubbles. When analyzing data, both the density of the bubbles and the size of the bubbles can be important indicators for predicting data trends. |
|
Combo | 250px|700px|reset | Suitable for showing data that requires multiple chart types (e.g. column chart, line chart, scatter chart). Using a dual axis combo chart is a good way to show data with large differences in magnitude. |
|
250px|700px|reset | Displays the differences between multiple numerical variables and is suitable for scenarios that require comprehensive analysis of multiple indicators. It can be used to show the relative strengths and weaknesses of different proposals. |
| |
250px|700px|reset | Suitable for extracting key information from large amounts of text data. Words are differentiated by color and font size based on frequency and intelligent analysis. |
| |
Funnel | 250px|700px|reset | Suitable for comparison and conversion analysis. The height and width of the different layers represent changes throughout the different stages of the process. |
|
| 250px|700px|reset | Shows the frequency and cumulative percentage of variables from highest to lowest, making it easy to spot the key factors that have the most impact. |
|
250px|700px|reset | A waterfall chart consists of multiple columns, with each column differentiated by color and direction to represent positive and negative values. Positive values stack upwards, while negative values stack downwards. It can be used to show the cumulative impact of positive and negative values on the final value . |
|
Note: For details on inserting different charts, click the relevant chart name in the table above.
III. FAQs