retable faq blue background
January 20, 2024

What is chart view?

If you're looking for a colorful way to get a big-picture overview of a spreadsheet, you can try the Retable's chart view.

The chart view summarizes a spreadsheet's data and helps you to visualize your records in multiple chart types including bar chart, line chart, area chart, pie chart.

From the "Views" tab on the left of the screen, click "Add New" and then choose "Chart View"

Chart Types;

  • Line charts are mostly used to track changes over time, but they can also be used for when there is some other sequence, like stages in a pipeline.
  • Area chart displays graphically quantitative data. It is based on the line chart. The area between axis and line are commonly emphasized with colors, textures and hatchings.
  • Bar charts are generally used to compare specific X-axis values, like the number of assignments each collaborator has in a project management base.
  • Pie charts are both useful in situations where you want to compare the relative proportions of a data set's constituent subsets.

Configure the x-axis and y-axis

Once you've picked a chart, you'll need to pick a field for your chart's X-axis.

Certain field types offer additional customization choices for the X-axis. You can also choose to whether or not to include data from cells that are empty in the specified field by selecting the "Include empty cells" option.

Once you've set up the X-axis, you'll need to set up the Y-axis.

By default, the Y-axis is configured to show Count. This means that the chart will plot the number of records that have each X value on the Y-axis. To use one of your other fields for the Y-axis, click the Field option.

Note that you have to pick a numeric field. You can either plot all of the values in the field, which is useful for a scatter plot, or you can select the values to show the sum, minimum or maximum of all of the values.

You can also make it more distinctive by giving colors.

Once you're done configuring the chart, you can hover over points on the chart to get more information about the underlying data.

You can also filter on the chart and share the chart you've created.