Chart & Visualization Issues

How to Fix Map Chart Border Colors Not Updating in Excel for Mac

Olivia MillerOlivia Miller Nov 10, 2026 869 views

Question details

The user needs to successfully apply and display solid border colors for all data regions in an Excel Map chart.

How to Fix Map Chart Border Colors Not Updating in Excel for Mac
Product
Microsoft Excel 365
Device & OS
macOS
Scenario
Customizing the visual boundaries of a map chart to improve readability and distinguish category data regions.
Observed behavior
After applying a solid line border color via the format pane, the borders for countries with category data remain completely transparent and fail to render.
Before you start

Ensure your Mac is connected to the internet, as Excel Map charts rely heavily on Bing Maps online services to accurately plot and render geographical boundaries.

Solution 1Recommended

Apply Solid Borders and Force a Chart Redraw

The most effective way to bypass this Mac rendering glitch is to apply your desired border color and then use a structural chart setting to force the graphical engine to redraw the visual elements.

Excel 365 for Mac occasionally experiences rendering delays or bugs where newly applied formatting does not immediately display on complex objects like map charts. By briefly changing the Gap Width, you prompt Excel to recalculate and redraw the chart, revealing your transparent borders.

1
Open Data Series Formatting

Right-click on the map chart in your worksheet and select 'Format Data Series' from the context menu to open the right-side formatting pane.

2
Set a Solid Border

In the formatting pane, navigate to the 'Border' section. Choose 'Solid line' and select your preferred color from the color picker.

3
Force a Visual Refresh

Switch to 'Series Options'. Locate the 'Gap Width' setting, change the percentage slightly, and then immediately revert it back to its original value. Your solid borders should now appear.

Apply Solid Borders and Force a Chart Redraw
Quick Refresh Shortcut: If you frequently adjust map charts, keep the Series Options pane open. Toggling structural settings is the fastest way to force Excel to update a stuck visual state.
Free Microsoft Office alternative

Create Professional Data Visualizations Without Glitches

Tired of encountering rendering bugs and formatting glitches in Microsoft Office for Mac? WPS Office provides a lightweight, highly compatible, and completely free alternative with a robust, stable data visualization engine.

  1. 1. Download and Install: Visit the official WPS Office website and download the free, lightweight installer for macOS.
  2. 2. Open Your Spreadsheets: Launch WPS Spreadsheet and seamlessly open your existing .xlsx workbooks.
  3. 3. Insert and Customize Charts: Highlight your data and use the Insert tab to build beautiful, instantly-refreshing charts and graphs.
Highly compatible with Microsoft Excel (.xlsx, .xls) files and standard chart formats.Lightweight installation tailored for excellent performance on both Mac and Windows.Stable chart rendering engine that instantly updates visual elements without tedious workarounds.Completely free to use with a familiar, user-friendly interface.
microsoft office alternative - wps office

Frequently Asked Questions

Why do my Excel map chart borders disappear on Mac?

This is typically caused by a known rendering glitch in Excel 365 for Mac. When category data is applied to certain regions, the chart's graphical engine occasionally fails to update the display cache, leaving the new border colors transparent until a redraw is forced.

Does this map chart workaround apply to Excel for Windows as well?

While this specific transparent border bug is more prevalent on macOS, the troubleshooting step of tweaking 'Gap Width' to force a visual refresh is a highly effective trick for resolving similar chart display freezing issues on Windows.

Can I change the border color of just one specific country in my Map chart?

In Excel, border formatting on a Map chart is applied universally across the selected data series. To single out one country, you cannot change just its border; instead, assign that country a unique value in your dataset so it adopts a distinct fill color based on your chosen map color scale.

What should I do if my map chart shows blank, gray regions even after formatting?

Blank or uncolored regions usually mean Excel's Bing Maps integration could not recognize the geographical names in your dataset. Ensure all country, state, or postal code names are spelled correctly and formatted as standard text.