For anyone coming across this post with a similar issue, I managed to find a workaround that enabled the Maps chart.
In my case, by opening Excel via the "Run as Administrator" option, I am able to access the Maps chart.
Worth trying if you're facing the same issue - best of luck.