Map charts

New Contributor

Hi,

I'm using MS Office 365 on PC/Windows 10 version 21H1.
I've been trying to create a map chart both in PowerPoint and Excel but have been unsuccessful.

Whichever way I do it, I cannot make the chart display correctly. First of all a message pops up and secondly, the adjusted data (by country) makes the whole map disappear, regardless of which display selection I choose (Automatic, country/region; multiple countries/regions; only regions with data; or World). Nothing I do makes the map display. I've attached screen shots for both pptx and xls which I hope are legible. Would anyone be able to tell me the reason why this happens, please? It's driving me nuts!

Thank you.

tribalartdesign63_0-1626347800111.png

 

3 Replies

@tribalartdesign63 

Map Charts is quite sensitive to column names and data layout, e.g.

image.png

If you use structured table and linked data types, it shows everything.

In the middle it shows only Ireland as Country.

If change Country on Province as in the latest sample, it shows all but Ireland.

 

I don't think it will properly work on generated by PivotTable data, at least you ay try with correct field names.

 

Hi @tribalartdesign63 

I tried to create map chart in Office365 hope you will like it.

Map Chart.pngWorld Map Chart.png

I used ChartExpo™ For Excel & Office365 to create these charts from few clicks.
There is no requirement of coding skills.

It is also available for Google Sheets.

 

Regards!

@Sergei Baklan Thank you, Sergei. Are you saying I need to add filters to the columns? When you insert a new map chart in PowerPoint it looks like the image below. There are no named columns. All I did was replace the existing labels/data - at which point everything disappeared, regardless of which map area I wanted to show.

After I added filters on the columns (2nd image below), I managed to show England and Scotland but as soon as I included the next Country and data into the selection, everything disappeared again and it didn't matter to what I changed the area selection. Once I included Ireland in the data set, it showed only Ireland and not the previous Countries in the data set. Again, no matter what area selection I chose.

I think I've worked out now that it's just not possible to show the UK only. I even rearranged the order of the Countries but it made no difference. I'm giving up on Map charts. They're a waste of time for my purposes and I won't be using them again until Microsoft have stabilised it and sorted out the Country shapes! 

Thank you very much for your help

tribalartdesign63_0-1626367895778.png