I have used www.craftmypdf.com and I have created good documents with the API between both tools. Here there is a link with the step by step process:https://craftmypdf.com/blog/how-to-automatically-create-pdf-event-passes-with-airtable/

I would try to create a filter for graph and showing only the information related with the year I want.