Hmm, could try looking at QuickCharts for this if you're comfortable with scripting, feels like you should be able to cobble something together from there

thanks for the help, but I hope there might be a faster and more common solution

Like Adam said above, you can use any charting or graphing software on the web that you'd like, and then you can automate it with Make's automations & integrations.

For example, you can use Make's QuickChart integrations or you can use Make's image-charts integrations or you can use any of the dozens of charting apps that Make natively supports.

If you want to use a charting app that isn't natively supported by Make, you can write your own custom API calls by using Make's HTTP modules.

If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread.

For example, here is one of the many ways that you could instantly trigger a Make automation from Airtable.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

for now, I'm looking for a solution without additional ie external software.
Thanks for the help anyway.