Depending on the complexity of the charts you need, there are a few options. Google sheets is good but you have limited visual editing options. Personally I either use Canva (the charts are under Elements, if you search for “charts”) or Keynote (free if you’re an Apple user). Keynote is actually quite amazing in the customisation area. These are good if you want “pretty” charts.
If you are looking for automaton options however, some of these might be a better option for you:
https://towardsdatascience.com/8-free-tools-to-make-interactive-data-visualizations-in-2021-no-coding-required-2b2c6c564b5b
The free options are limited but you might find one that works