Chart types

Change the chart type

After adding a chart, you can select the chart type on the right-hand menu.
The following chart types are supported:
  • Bar chart
  • Line chart
  • Area chart
  • Pie chart
  • Donut chart
  • Scorecard chart
For all chart types, you need to select a table as the Data Source. You can also optionally select a view, which can be helpful when you want to filter the data.
The next steps depend on the chart type.

Bar, Line & Area charts

  • Select an X-axis field.
    • Optionally, select a Range for the axis values.
    • If the x-axis field is a date or date time field, you can select a Bucket by rule for the axis values.
  • Select one or more Y-axis series.
    • Optionally, select a Range for the axis values.
    • Optionally, turn on Aggregate values to calculate an aggregate function for each point on the series.
  • Choose whether to Sort the values by the X-axis, Y-Axis or the Data Source View. If the x-axis field is a date or date time field, this option is not available as the values are sorted chronologically.

Pie & Donut Charts

  • Select a Categories field. This will be the field that you want to use to categorize/split up the data. It's most likely a single select field in Airtable.
  • If you simply want a count of the records in each category, select 'Record count' for the Aggregate in the Values section.
  • If you want a more complex aggregate function, select a Field and an Aggregate function. E.g. the 'Max' value in the 'Cost' field for each category:

Scorecard charts

Scorecard charts show a summary number.
  • Select an Aggregate function to use. Select 'Record count' to get a count of the records in the table/view.
  • If you want a more complex aggregate function, select a Field as well an Aggregate function. E.g. the 'Max' value in the 'Cost' field for each category: