Best solution to generate reports locally with graphs, charts? Beginner question.

So on a local lm like ollama, or lm studio etc. you can run questions and prompts. But it’s a text response and I am unable to have it generate pdfs or report files graphs. Such as a pie chart on my invoices. Or create a report for me on statistics. When I run kimi, or Claude they can generate reports with visual media in them. Is there a way relatively simple or how to get it working on the local lm. I started looking to a local n8n if there are some things I can do but trying to see how is the simplest way to do this for some nice reports based on data gathering.