This automation allows you to create and embed a simple dynamic chart based on your data in Airtable into your website.
All you need to do is to select the table>view>fields where the data is stored and a chart will be generated for you.
Demo
Here are some sample charts that have been embedded in this page:
Features
- Supports two different chart types (bar and line).
- Customizable chart size.
- Chart data is always up-to-date.
If you click on the sample view below, you’ll see the table that’s used for the demo above.
I’m having trouble getting my data to chart the correct way. I’m attempting to create a graph for financial metrics (6 total data points) for one particular record. I have those 6 data points as individual column headers in Airtable. When i select the Y axis, I can only select one of those data points.
That’s not how charts work. Instead of having the data points in different columns (fields), they should be in individual rows (records).
So if one company has 2018 2019 and 2020 Revenues, how would that be all in one row? Meaning, the columns title “2019 Revenue” “2020 Revenue” and the info would be under those all in the same row as the company.
Each year would be in a separate row. Our extension works in a similar way of how the chart app works in Airtable. This page has some info that can help you with the data set up. I’m not sure how your data looks like, but it seems like it’s not in a raw format. Also, our chart extension does not support data grouping. So if you have data for multiple companies in different years, you would not be able to group them by the “Company” field.