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.

Trying to avoid subscriptions and more things I need to add if possible.