Skip to main content

How to set a chart


For different charts, the details may be configured differently, but the setup ideas are generally the same, including the following:

  1. Create a new chart

  2. Set the data range

  3. Select the chart type

  4. Configure the chart

  5. Basic operations of charts

Create/Manage Chart

1. Create a new chart

Click the [Stats] button in the worksheet to enter the chart panel, and click the [+] to create a chart.

Public: The public chart is visible to all members of the worksheet.

Personal: Only you can see the chart.

Personal and public charts can be converted to each other.

It is recommended to create a personal chart first, and convert it to a public chart if needed after the configuration is complete.

2. Set the data range

First of all, you need to determine which data to be counted.

Data Source: By default, all records in the current worksheet are selected. A view can also be selected.

Time: Select a time field (date created, date modified, or other date field). For the time range, you can choose a fixed time period (today, yesterday, this week, last week, this year, last year...) , or customize the time period.

Filter: You can further filter the records by a field. Drag and drop the field from the left to configure it.

With the above, you can determine the range of data.

Is there a limit to the numbers of records in the chart?

There is no limit on the number of rows of data, but there is a limit on the number of legends in the chart. For example, a pie chart can only have a maximum of 500 pie blocks (legend); a column chart supports a maximum of 5000 columns (legend).

  • Pivot Chart: no limit
  • Pie Chart: 500
  • Other Charts: 5,000

If the number of legends exceeds the limit, the following message will be displayed.

3. Select the chart type

Currently, HAP supports 16 types of charts, including column chart, horizontal bar chart, symmetric bar chart, line chart, biaxial chart, scatter diagram, radar chart, pie chart, funnel chart, word cloud, pivot chart, number chart, dashboard, progress bar, ranking list, and administrative division. For different types of charts, different properties need to be set.

4. Set the dimensions and indicators of the chart

Take the column chart as an example

Set the statistical dimensions

  • X-axis

    That is, the statistical dimension, the data displayed on the horizontal axis.

  • Y-axis

    That is, the indicator value. You need to select the numeric, formula or level field. If it is a numeric field, you can also set whether it is a sum, average, maximum or minimum value.

    For the formula or level field, you can set [Count] or [De-duplicate and Count].

  • Grouping

    Group and count the data of X-axis further.

5. Style

You can enable or disable more chart styles.

6. Analyze

For results, you may need to view the original data or add one or more auxiliary lines to help analyze the data.

7. Set the name/description of the chart

Click on the top left of the chart to set the chart name and description. Finally, click [Save] to finish the chart configuration.

8. Modify the configuration

When you need to modify the configuration of the chart, you can click [...] > [Settings] to reconfigure.

9. Conversion of personal and public charts

  • If a public chart is converted to a personal chart, it is only visible to the chart creator (it is also not visible to the operator if the operator and the creator are not the same person).

  • If a personal chart is converted to a public chart, the chart is visible to everyone who can see the worksheet.

10. Sort charts

Administrators can click the top left button of a chart and drag it up and down to adjust the order. The new sorting is valid for all members.

11. Copy charts

Administrators can copy charts and the new charts can be stored in either:

  • In the statistics module of current worksheet

  • In a custom page. You can select custom pages of all applications in the current organization for which you are an administrator.

12. Chart sharing

Administrators can enable [Public Sharing] of a chart, and other members of the application can share the link or QR code to the public.

User Operations

Users can filter, sort, export, save as image, share charts, etc. when viewing.

1. Zoom in a chart

2. Filter and sort

Filter: Based on the administrator's configuration, users can further filter. The filtered data will not exceed the configured range.

Sort: Only single dimension sorting is supported.

3. Share a chart

You can share the chart's link or QR code to other users.

Chart sharing is disabled by default. Only administrators can enable it.

4. Export a chart

You can export the chart to Excel, and the exported file name is the name of the chart by default.

Only pivot chart is exported directly in the style of a chart, other types of charts are exported as visual data, not as a chart. A set of x and y corresponds to a row of data in the Excel sheet.

For example, for a column chart

  • In an Excel sheet, the title of the first row is the dimension and the title of the first column is the grouping (if any).

  • If there is no grouping and the y-axis has more than one value, the column names starting from the second column are the names of the value objects respectively.

In the exported Excel sheet, the row dimension is the date created and the column dimension is the grouping (name).

5. Display in a table

You can click the icon on the top right to set the chart's data source to be displayed in a separate column on the bottom or right side of the chart.

6. Save as image

For charts such as column charts and line charts, you can save them as images.

7. Format of exported data

When exporting, you can choose to export by original data or by display unit.

8. Adjust column width

For pivot charts, you can drag and drop columns to adjust the width, or display them in equal parts by default.


Have questions about this article? Send us feedback