Help

Re: Clustered Bar Chart

Solved
Jump to Solution
3865 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Chris_McMahon1
4 - Data Explorer
4 - Data Explorer

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
Mohamed_Swella1
13 - Mars
13 - Mars

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

4 Replies 4
Mohamed_Swella1
13 - Mars
13 - Mars

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

Hi. Is the "Charts & Reports" extension available within Interfaces?