Update embedded excel containing sql in powerpoint

Hello,

I am trying to create a powerpoint presentation containing 60-70 slides which will be updated monthly. I would like to make it as automated presentation as possible.

Therefore I thought i would use embedded excel tables to populate the powerpoint charts. However, I cant refresh these the data in an easy way.

Currently, i am required to do the following:
1) Right click on each PPT chart and go to Edit Data. See attached pic Powerpoint1
2) An excel file named Chart in Microsoft Powerpoint opens up.
3) I need to right click on the data table and press refresh. See attached pic Powerpoint2

I need to repeat the procedure above for every chart.

Is there a smarter way of doing this? Perhaps with VBA and macros. Btw, really annoying that macro record is not working with PPT