Skip to main content
Question

How to create a grouped bar chart (3 values per category) in Interfaces?

  • August 29, 2025
  • 1 reply
  • 40 views

Forum|alt.badge.img+3

Hi everyone,

I’m trying to build a chart in Airtable Interfaces to compare three values for the same category:

  • Budgeted amount

  • Consumed amount

  • Imputed amount

Right now, in Interfaces I can only create basic charts (bar, line, pie, donut, scatter), but I haven’t found a way to display these three values together as grouped series in a single chart.

Ideally, I’d like to have something like a grouped bar chart or a pivot-style view, where for each budget item I can quickly see the three numbers side by side.

Is there any way to do this directly in Interfaces? Or maybe through a workaround (extensions, pivot table, or calculated fields) that can then be brought into the Interface view?

Thanks a lot for any tips or examples!

1 reply

TheTimeSavingCo
Forum|alt.badge.img+31

I think you might need to create a new table where each record represents a single amount I’m afraid

And so assuming your data looks like this:

Then you’d need a table like this:

Which would let you create this, where the X axis is the Category, and the Y axis is a sum of the Amount, grouped by Type