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? otherwise I will have to use a different application. Thanks

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.

@JuanTroubleshooting I'm down to 3 regions not recognized... New South WalesVictoriaQueenslandWestern AustraliaSouth AustraliaTasmaniaAustralian Capital TerritoryNorthern TerritoryJervis Bay TerritoryNorfolk IslandChristmas IslandCocos (Keeling) IslandsAustralian Antarctic TerritoryCoral Sea Islands TerritoryAshmore and Cartier IslandsHeard Island and McDonald Islands

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.

Hi davidstudent,I did quite a bit of digging. I successfully replicated your "what seems to be a bug" and got same results, no matter the values or number of locations included. I also looked on other forums - it turns out that this problem is a thing. Microsoft doesn't seem to have worked it out yet (if they even investigated it in the first place). I would advise You to look for a different software for this scenario.Cheers!

Thanks a lot for your assistance Maciej_Kopczynski Wish they would fix it 😞 was so simple to create

Data applied to Map Chart - Australia wrong shape and size

JuanTroubleshooting
Copper Contributor
Mar 08, 2024
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.
- hogwash
  Copper Contributor
  Mar 09, 2024
  JuanTroubleshooting would be grateful if you could please post the territories names that worked for you, as Excel likes to have them?
  - hogwash
    Copper Contributor
    Mar 09, 2024
    @JuanTroubleshooting
    
    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
Maciej_Kopczynski
Brass Contributor
Feb 04, 2024
Hi davidstudent,
I did quite a bit of digging. I successfully replicated your "what seems to be a bug" and got same results, no matter the values or number of locations included. I also looked on other forums - it turns out that this problem is a thing. Microsoft doesn't seem to have worked it out yet (if they even investigated it in the first place). I would advise You to look for a different software for this scenario.
Cheers!
- davidstudent
  Copper Contributor
  Feb 04, 2024
  Thanks a lot for your assistance Maciej_Kopczynski
  Wish they would fix it 😞 was so simple to create
JeffIvey9
Copper Contributor
Feb 16, 2024
davidstudent
I have just experienced the same issue. The area showing for Australia is actually the state of Tasmania (part of Australia)
I don't have a solution, just a little further explanation of what's happening
- Riny_van_Eekelen
  Platinum Contributor
  Feb 16, 2024
  JeffIvey9
  Same question as when I answered you on the Answers forum!
  
  Can you include a screenshot of your data table and describe exactly how you built the map? And what Excel version are you on?
  - JeffIvey9
    Copper Contributor
    Feb 16, 2024
    Riny_van_Eekelen
    I highlighted the data, clicked on Insert -> Maps -> Filled Maps
tscott660
Copper Contributor
Mar 25, 2024
This worked for me from a reddit post

1.Close everything
2. Open a new workkbook
3. Plot the same data but open it on 3D MAP option
4. browse around the 3D map
5. Return to same sheet and it should appear correctly.

Forum Discussion

Data applied to Map Chart - Australia wrong shape and size

Share

Resources