Hello,

I currently have an excel sheet that contains countries and their associated categories. Example:

Countries:CategoriesUnited StatesCategory 1RussiaCategory 2ChinaCategory 3

When I insert a Map from this data, the countries that I list get colored according to the category and receive a transparent border (hard to tell since the background is white but when copied into PowerPoint the borders appear transparent).  When I change the border color for the series under ‘Format’ and ‘Series’ and ‘Border’, ‘Solid Line’, it changes the border color for all countries for which no data is provided, but leaves the transparent borders untouched.  How can I change the border color of all my countries which have category data? I am able to manually change each border color individually, but I want a way to change all the borders at once and without using vba.

Also, I am using Excel 365 for Mac—there seem to be some differences in application type.

Thanks!

​Hello,I currently have an excel sheet that contains countries and their associated categories. Example:Countries:CategoriesUnited StatesCategory 1RussiaCategory 2ChinaCategory 3When I insert a Map from this data, the countries that I list get colored according to the category and receive a transparent border (hard to tell since the background is white but when copied into PowerPoint the borders appear transparent).  When I change the border color for the series under ‘Format’ and ‘Series’ and ‘Border’, ‘Solid Line’, it changes the border color for all countries for which no data is provided, but leaves the transparent borders untouched.  How can I change the border color of all my countries which have category data? I am able to manually change each border color individually, but I want a way to change all the borders at once and without using vba.Also, I am using Excel 365 for Mac—there seem to be some differences in application type.Thanks!  Read More

​