Skip to main content

Pivot Chart

Features: A pivot chart is an interactive table for quickly summarizing data with cross-tabulations. It helps users to analyze and organize data.

The following is an example of how to create a pivot chart.

Example: In the worksheet Sales, create a chart to analyze and display the sales of this month​

Data range: Sales records in this month

Filtering field: Date created

Time range: This month

Numeric: Region, Product, Date, Amount

1. Create a new chart​

2. Set the data source​

3. Select the [Pivot Chart]​

4. Set the dimension​

Row: region, product

Column: date (day)

Numeric: total sales amount

When setting the dimension, you can set the display field of the associated worksheet if you select the field in the associated worksheet.

5. Preset style​

Set the color of the row or column header.

6. Cell​

Here set the color of the cell and how to display it.

7. Row/Column title​

In the preset style, you can also set the color of the table header, alignment and background color.

Whether to freeze the row/column headers on pc or mobile.

8. Display settings​

Here set whether to enable row totals or column totals and how to display them.

For row totals or column totals, you can set the rollup method depending on the selected field, which may be different for each field.

Name: click to modify

Hint: you can set to add some hints in front of the field

Location: you can set the placement of the summary column

9. Single line height​

In the pivot chart, it defaults to adaptive height to display the full content. If enabled [single row height], it will fix the line height to show only one line of content, and the content beyond will be displayed as an ellipsis.

10. Data filtering​

You can set to show only the first X items of the row or column.

11. Show unit​

For numeric fields, you can set the unit and the number of decimal places.

12. Save​

Effect:

Have questions about this article？ Send us feedback