Forum Discussion

ebreese's avatar
ebreese
Copper Contributor
Jul 24, 2020
Solved

Map function using Australian Local Government Areas

Hi all, trying to use the map chart function with Australian Local Government Areas. Postcodes work fine, as do suburbs, however when trying to use Local Government Areas the map refuses to recognise...
excel
  • IngeborgHawighorst's avatar
    IngeborgHawighorst
    Jul 24, 2020

    Hello ebreese , 

    the data that can be processed by filled maps can be very sketchy for locations outside the US. It may well be that the rendering engine does not recognise the boundaries for the local government areas you mention, because it does not fit into the schematic of how Microsoft / Bing breaks things down. They don't have much tolerance for non-US data. If I want to plot NZ data, I have to call the column "regions", if I call it "region" (singular) I get the same error you do.

     

    There's probably not a lot you can do, except to send feedback via the smile icon in the upper right hand corner of the Excel window.

     

    Don't shoot the messenger.

mbowd1905's avatar
mbowd1905
Copper Contributor
May 24, 2021

ebreese 

 

Hi Emlyn, I have the same issue, how did you go with your search? I want my Excel Map to pick up LGA data from my spreadsheet but not sure what to call the Header of that column? Any ideas?

 

Thanks Mike

 

mbowd1905's avatar
mbowd1905
Copper Contributor
May 24, 2021

mbowd1905 

 

Hi Emlyn, I will be trying "sa3_code" as my column header.  I note these are not necessarily "LGA" but it will do me. Excel maps the location areas when I use those codes. I've used the sa3 codes from the following fine piece of work.

 

https://www.kaggle.com/therohk/australia-sa2-codes-browser?select=sa2_2016_aust_csv.zip

 

Cheers Mike

 

Resources