Excel Bug - Including the Congo in Map Charts Bug in Excel: Mapping the Congo - Episode 2063a

1,637 views · Published 24 March 2017 · 1:31 · Indexed 16 November 2026

Channel: MrExcel.com · 2017 · Education

Watch on YouTube

Microsoft Excel Tutorial: Bug in the Map Charts in Excel for Democratic Republic of the Congo is misspelled.

Welcome back to another episode of the MrExcel netcast. In this episode, we're going to be discussing a bug in Excel that has been causing some frustration for users. Specifically, we'll be looking at how to properly map the Democratic Republic of the Congo in Office 365's new Map Charts feature.

Recently, a bug has been reported on the message boards where only four out of five countries are showing up on the map, even though all five are listed in the data. After some investigation, it was discovered that the issue lies with the spelling of the Democratic Republic of the Congo. For some reason, the map is not recognizing the country when it is spelled correctly with the final "o". This means that in order for the country to appear on the map, the final "o" must be removed from the spelling.

This is not only a frustrating issue for users, but also a slight to our friends in the Democratic Republic of the Congo. No one should have to spell their own country's name incorrectly just to have it show up on a map. However, there is a simple workaround for this bug. By using a custom format in the cells, we can make the country name appear correctly in both the cell and on the map. This trick can also be applied to other words that end in "o" to save time and avoid extra typing.

To use this workaround, simply select the cells with the country names, press Ctrl+1 to open the Format Cells menu, and choose the Custom option. Then, in the Type field, enter the @ symbol followed by "o". This will ensure that the final "o" is added to the end of the country name, making it appear correctly on the map. I hope this solution helps those who have been struggling with this bug in Excel. Thanks for watching and don't forget to subscribe to our channel for more helpful tips and tricks!"

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

#excel
#microsoft
#microsoftexcel
#exceltricks
#excelhacks
#microsoft365
#numberformatting
#excelcharts
#excelmaps

This video answers these common search terms:
how to do map chart in excel
how to get map charts in excel
how to make map charts in excel
how to add a map chart in excel
how to make a map chart from excel
how to use excel map chart
how to create an excel map chart?
bug in excel map chart for congo

Table of Contents:
(00:00) Excel Map Charts misspell Congo
(00:22) Bug can be fixed by removing final "o" in spelling
(00:32) Displaying Congo when Cong is stored
(00:47) Custom formatting can make spelling appear correct
(01:00) Using "@" symbol for custom formatting and adding "o"
(01:15) Clicking Like really helps the algorithm

There is an odd bug in Office 365 - when you insert a map chart, it won't recognize the "Democratic Republic of the Congo". You have to misspell it as "Democratic Republic of the Cong". In this temporary episode, a bizarre workaround to get the final o back into the cell.

Join the MrExcel Message Board discussion about this video at  https://www.mrexcel.com/board/threads/1153892/

More from this channel