Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Recreating Chart from Excel in Airtable

Topic Labels: Extensions
Solved
Jump to Solution
1187 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!