Recreating Chart from Excel in Airtable

[lgue_airtable]

Hello,

I am trying to create a stacked bar graph in Airtable like the one I made in excel, but there's something I'm not quite understanding about how the chart extension tool works in Airtable. I cannot group the different day ranges under the record #, only the total, not the individual segments stacked. Any help would be appreciated, thanks.

  

[TheTimeSavingCo · Accepted solution]

Hmm, could you provide a screenshot of the way your data's set up?

I managed to create this:

And my data's set up like so:

Link to base

Might need to manipulate your data a bit so that the chart can display it the way you want!

[lgue_airtable]

Thanks for responding Adam, you are correct that I needed to manipulate my data to display the chart in the way I wanted.

One last thing, how did you get the stacked bar chart to be horizontal in Airtable? I can only get it to be vertical.

Thanks again!

[TheTimeSavingCo]

Ah, it's in the "Appearance" tab found here:

[lgue_airtable]

Interesting, I think we might be using different Extensions.

[TheTimeSavingCo]

Ah, yeah, I'm making a chart in an interface, sorry about that!