Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Clustered Bar Chart

Topic Labels: Extensions
Solved
Jump to Solution
1936 3
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello, I am relatively new to Airtable and I am having difficulty creating a simple clustered bar chart in the chart block. In excel my table and chart looks like this…
clustered bar chart
Any suggestions?

1 Solution

Accepted Solutions

Hi @Chris_McMahon1,

Welcome to Airtable Community! :slightly_smiling_face:

Airtable does not do charts from 2 different fields in one graph (unless you want to use the Vega Lite block which needs some coding skills).

The way around that is to have each record duplicated, mark one as Meters Upgraded and one as Remaining To Complete (using a single selecet option for example).

If that helps, please mark this as Solution so others can see it.

BR,
Mo

See Solution in Thread

3 Replies 3

Hi @Chris_McMahon1,

Welcome to Airtable Community! :slightly_smiling_face:

Airtable does not do charts from 2 different fields in one graph (unless you want to use the Vega Lite block which needs some coding skills).

The way around that is to have each record duplicated, mark one as Meters Upgraded and one as Remaining To Complete (using a single selecet option for example).

If that helps, please mark this as Solution so others can see it.

BR,
Mo

Thanks for the response Mo, I will give it a try.

Chris

Hey, there is no way to do this with the Chart extension and Vega-Lite requires you to write JSON. But it's easy to do with our new extension, Charts & Reports - you can add multiple bars for each x-axis value and customize the color of each.

Screenshot 2022-12-05 at 12.01.12.png