'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix 3D Maps and Power Map Missing in Excel for Mac
Question details
Users are unable to find the 3D Maps (formerly Power Map) feature in Excel for Mac.
- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- Attempting to insert a 3D Map or use Power Map for data visualization and geographical analysis.
- Observed behavior
- The 3D Maps, Power Map, and certain Data Model components are completely absent from the Insert and Data tabs in the Mac version of Excel.
Verify that your Mac has sufficient storage space and memory (RAM) to run a virtual machine, and ensure you have access to your Microsoft 365 account credentials.
Use Excel for Windows via Virtualization (Parallels Desktop)
Because 3D Maps is a Windows-exclusive feature, the most reliable workaround is to run the Windows version of Excel on your Mac using a virtual machine.
Features like 3D Maps and certain advanced Data Model tools rely heavily on DirectX and other native Windows components. Since these are not built into macOS, Microsoft has not ported these features to Excel for Mac.
By using software like Parallels Desktop, you can run a full version of Windows alongside macOS without rebooting, allowing you to use the fully-featured Windows version of Excel.
Download and install Parallels Desktop for Mac from their official website.
Launch Parallels and follow the Setup Assistant prompts to download and install the Windows operating system.
Once your Windows virtual machine is running, open a web browser inside Windows, log into your Microsoft 365 account, and download the Office suite.
Open the newly installed Windows version of Excel, go to the 'Insert' tab, and you will now see the '3D Map' button available in the Tours group.
Submit a Feature Request to Microsoft
If you prefer not to use a virtual machine, you can formally request that Microsoft bring 3D Maps to the macOS version of Excel.
Try WPS Office for Seamless Cross-Platform Data Analysis
While advanced Windows-only features like 3D Maps are absent in Excel for Mac, WPS Office provides a robust, lightweight, and completely free alternative for Mac users. Enjoy seamless compatibility with Microsoft formats, familiar interfaces, and powerful data visualization tools without the need for complex virtual machines.
- 1. Download for Mac: Navigate to the WPS Office website and download the native macOS installation package.
- 2. Install and Open: Drag the application to your Applications folder and open WPS Spreadsheet.
- 3. Visualize Your Data: Import your Excel workbooks directly and use the comprehensive chart library to analyze your data seamlessly.
Frequently Asked Questions
Why did Microsoft leave 3D Maps out of Excel for Mac?
3D Maps heavily relies on DirectX, a graphics API exclusive to the Windows operating system. Because macOS uses a different graphics framework (Metal), porting the feature requires rebuilding it entirely, which Microsoft has not yet done.
Can I use Boot Camp instead of Parallels Desktop to get 3D Maps?
Yes, if you have an older Intel-based Mac, you can use Boot Camp Assistant to install a native Windows partition for free. However, Boot Camp is not supported on newer Apple Silicon (M1/M2/M3) Macs, making virtualization software like Parallels the only option for modern Macs.
Are there other Data Model features missing on Excel for Mac?
Yes. Excel for Mac lacks several advanced Business Intelligence (BI) tools available on Windows. For example, Power Pivot is entirely absent, and while Power Query has recently been added to Mac, it still lacks some advanced data import and transformation capabilities found in the Windows version.
Is there a native Mac alternative for geographical mapping in Excel?
While 3D Maps is unavailable, Excel for Mac does support basic 2D Map Charts. You can select your geographical data, go to the Insert tab, and choose 'Maps' to create a flat, 2D map visualization of your data.
