Skip to main content
Solved

Recreating Chart from Excel in Airtable


Forum|alt.badge.img+3

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.

  

Best answer by TheTimeSavingCo

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!

View original
Did this topic help you find an answer to your question?

5 replies

TheTimeSavingCo
Forum|alt.badge.img+28

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!


Forum|alt.badge.img+3
  • Author
  • New Participant
  • 2 replies
  • March 20, 2024
TheTimeSavingCo wrote:

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!


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
Forum|alt.badge.img+28
lgue_airtable wrote:

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:


Forum|alt.badge.img+3
  • Author
  • New Participant
  • 2 replies
  • March 21, 2024
TheTimeSavingCo wrote:

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


Interesting, I think we might be using different Extensions.


TheTimeSavingCo
Forum|alt.badge.img+28
lgue_airtable wrote:

Interesting, I think we might be using different Extensions.


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


Reply