Urgent help needed: Importing excel data chart into InDesign while keeping text editability

Hello everybody!
I am unsure if this issue counts as a relevant case for this subreddit, as indesign is involved, but due to the importance of the issue, I figured I'd post my problem here as well, in hopes the answer can be found somehow.

I am currently heavily struggling with this task and I just couldn't find a solution online for it yet. The situation is as follows:

I need to add charts to an indesign file, which are generated inside excel files. The charts need to be placed into indesign and allow for any and all text on that chart to be editable and all other shapes should be vector objects.

I already know ctrl+D allows placing an excel table into indesign while maintaining editability, however this doesn't include a chart that was generated using data within that excel file. When I save the charts as .SVG files all elements stay intact and I have all editability options, including text, however I can't get a .SVG file into indesign while also maintaining that same editability, so that option is supposedly no longer on the table.

To summarise the dynamic of this project, I am currently tasked to insert 4 charts of data into a prepared layout, that needs all text and elements to remain editable and not linked outside of the indesign file. I will have to repeat those 4 charts for 47 times, as this is data for 47 different countries. My instincual solution is saving all charts as .SVG. Creating frames that display the charts in the exact position they need to be and then mass-place them using the indesign data merge function. But this will only leave linked image frames, when I was specifically asked to make all charts editable within indesign without any external linking.

Can anyone help me with this exact issue? I'm losing more and more time trying to find a solution for this issue and pressure to get this done or make progress is increasing, so I happen to be in quite the pickle. Any and all help greatly apprechiated!

EDIT:
Thank you for all the effort to help me with this issue, I wish it was as simple as just solving the above stated project related problem, however the more I am dealing with this project, the more I am realising that most of the problems are outside of this task and more work-related. I definitely learned some new things thanks to the responses, but I'll have to somehow deal with this beyond the practical solution itself.