How to automatically pull data from Excel into Powerpoint charts?

Hi, im an intern at a media company. I’m asked to automate the pulling of data from Excel into Powerpoint charts.

Instead of using macros, are there any other ways to automate things? Furthermore, if there is an update in data (in Excel), how can I get it to show in the charts (in ppt) as well?

The data in Excel are actually raw data obtained from some software which runs the data from a database. It may not be cleaned yet. Is there any way to get all the details we want from the excel to be displayed in charts(pie, bar, line)in Powerpoint itself??