Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Recreating Chart from Excel in Airtable

Topic Labels: Extensions
Solved
Jump to Solution
1814 5
cancel
Showing results for 
Search instead for 
Did you mean: 
lgue_airtable
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

Capture.PNG

Capture2.PNG

  

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

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

I managed to create this:

Screenshot 2024-03-20 at 10.18.06 AM.png
And my data's set up like so:
Screenshot 2024-03-20 at 10.17.10 AM.png

Link to base

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

See Solution in Thread

5 Replies 5
TheTimeSavingCo
18 - Pluto
18 - Pluto

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

I managed to create this:

Screenshot 2024-03-20 at 10.18.06 AM.png
And my data's set up like so:
Screenshot 2024-03-20 at 10.17.10 AM.png

Link to base

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

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!

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

Screenshot 2024-03-21 at 10.57.27 AM.png

Interesting, I think we might be using different Extensions.

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