Forum Discussion
Map charts
Map Charts is quite sensitive to column names and data layout, e.g.
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.
SergeiBaklan 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 🙂