A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Hi LEIB
PowerMap/3D maps for Excel were implemented in Excel for Windows at a time when the Mac and Windows Excel teams were separate and were allowed to make OS specific features as long as the files were compatible (would not break even if the feature would not work) on the opposing platform. Most of those features remain, but starting with Office 2016 the rules changed and cross-platform equivalency has been the rule of the day since.
PowerMap/3D Maps rely on COM add-ins, which are Windows-only and rely on the Microsoft Windows operating system. Active-X is Windows only. The data model and PowerPivot are Windows-only.
Support for AppleScript and Objective-C programming language extensibility is Mac-only.
Since 2016 Microsoft has dramatically narrowed the feature-gap between Excel for Mac and Windows.
Specifically regarding the 3D Maps feature, your Mac is plenty powerful enough to run that feature. You can run Excel for Windows in a virtual machine using Parallels and you will be able to use the 3D maps feature with ease.
The way things worked back in the day was Microsoft would test new potential features and release them as add-ins. Successful features then would get integrated into the main product. 3D Maps never made it to the main product. Personally, I love that feature, but I found the interface clunky and the maps hard to work with. Because they don't work on Mac, I never promoted the feature.
In my way of looking at things, Microsoft made a bad mistake by making the data model and COM add-ins dependent on Windows.. It was a quick and dirty way to get the features up and running quickly. It appears the 3D map feature wound up in limbo. It didn't make the cut into the code base of Excel, but it didn't go away.
In order for the data model to work in Excel for Mac, Microsoft will have to redesign the data model. Then they will have to re-do PowerPivot, and then they could do 3D maps for Mac, and hopefully this time around make it a robust, much easier to use and understand feature.
You can leave feedback specific to Excel for Mac using the Help Menu and choosing I Have a Suggestion.