Forum Discussion
davidstudent
Feb 04, 2024Copper Contributor
Data applied to Map Chart - Australia wrong shape and size
Hi all, I'm plotting my data on the map chart to show global spread however Australia is showing up tiny on the map (far smaller than New Zealand - see below) - does anyone have a solution? other...
hogwash
Mar 09, 2024Copper Contributor
JuanTroubleshooting would be grateful if you could please post the territories names that worked for you, as Excel likes to have them?
hogwash
Mar 09, 2024Copper Contributor
I'm down to 3 regions not recognized...
New South Wales
Victoria
Queensland
Western Australia
South Australia
Tasmania
Australian Capital Territory
Northern Territory
Jervis Bay Territory
Norfolk Island
Christmas Island
Cocos (Keeling) Islands
Australian Antarctic Territory
Coral Sea Islands Territory
Ashmore and Cartier Islands
Heard Island and McDonald Islands
- JuanTroubleshootingMar 10, 2024Copper Contributor
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.
- tscott660Mar 21, 2024Copper Contributor
I had this issue today. Not only is it frustrating to not be able to generate a map for an article, as an Australian I feel quite insulted