User Profile
JuanTroubleshooting
Copper Contributor
Joined 2 years ago
User Widgets
Recent Discussions
Re: Data applied to Map Chart - Australia wrong shape and size
hogwash When I manually enter the subdivisions "Ashmore and Cartier Islands, Australian Antarctic Territory, and Coral Sea Islands Territory" as text data types along with the other Australian subdivisions, then Excel charts only Australia. If I included subdivisions from other countries to the list as data types, Excel charts Australia and the other subdivisions from the other countries in the world map. But, if I enter "Australia" along with other country names as a text data types, Excel won't chart Australia. If my list includes text data types (Australia and New Zealand) and geographic data types (United States), Excel charts the United States properly (blue), New Zealand in gray, and Australia is not charted at all. Finally, I also noticed that even though Excel charts New Zealand, Excel is also missing three of its subdivisions (shown in gray in map below): "Bay of Plenty, Greater Wellington Regional Council, and Nelson, New Zealand." I need to map 33 countries including Australia, so my only solution at this time is to map them by region (subdivision) which is way more work than I need to do.Re: Data applied to Map Chart - Australia wrong shape and size
Hi... I have the same issue reported here and I may have found an error source. The excel geography data for Australia is missing two subregions: 1) Ashmore and Cartier Islands and 2) Australian Antarctic Territory. If I try to map Australia, I only get Tasmania and some of the islands. If I enter all 16 states and territories in individual cells manually, excel maps all of Australia correctly.
