SOLVED

Map function using Australian Local Government Areas

%3CLINGO-SUB%20id%3D%22lingo-sub-1542814%22%20slang%3D%22en-US%22%3EMap%20function%20using%20Australian%20Local%20Government%20Areas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1542814%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%20trying%20to%20use%20the%20map%20chart%20function%20with%20Australian%20Local%20Government%20Areas.%20Postcodes%20work%20fine%2C%20as%20do%20suburbs%2C%20however%20when%20trying%20to%20use%20Local%20Government%20Areas%20the%20map%20refuses%20to%20recognise%20it%20as%20geographical%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20tried%20both%20with%20setting%20the%20data%20as%20geographical%20and%20tying%20it%20to%20the%20correct%20entry%2C%20and%20as%20just%20plain%20text.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20tried%20including%20Country%2FState%20as%20additional%20columns%2C%20but%20still%20no%20luck.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20assistance%20would%20be%20greatly%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEmlyn%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1542814%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1542859%22%20slang%3D%22en-US%22%3ERe%3A%20Map%20function%20using%20Australian%20Local%20Government%20Areas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1542859%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F738395%22%20target%3D%22_blank%22%3E%40ebreese%3C%2FA%3E%26nbsp%3B%2C%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ethe%20data%20that%20can%20be%20processed%20by%20filled%20maps%20can%20be%20very%20sketchy%20for%20locations%20outside%20the%20US.%20It%20may%20well%20be%20that%20the%20rendering%20engine%20does%20not%20recognise%20the%20boundaries%20for%20the%20local%20government%20areas%20you%20mention%2C%20because%20it%20does%20not%20fit%20into%20the%20schematic%20of%20how%20Microsoft%20%2F%20Bing%20breaks%20things%20down.%20They%20don't%20have%20much%20tolerance%20for%20non-US%20data.%20If%20I%20want%20to%20plot%20NZ%20data%2C%20I%20have%20to%20call%20the%20column%20%22regions%22%2C%20if%20I%20call%20it%20%22region%22%20(singular)%20I%20get%20the%20same%20error%20you%20do.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThere's%20probably%20not%20a%20lot%20you%20can%20do%2C%20except%20to%20send%20feedback%20via%20the%20smile%20icon%20in%20the%20upper%20right%20hand%20corner%20of%20the%20Excel%20window.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDon't%20shoot%20the%20messenger.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1546057%22%20slang%3D%22en-US%22%3ERe%3A%20Map%20function%20using%20Australian%20Local%20Government%20Areas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1546057%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7724%22%20target%3D%22_blank%22%3E%40Ingeborg%20Hawighorst%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20Ingeborg%2C%20I%20had%20a%20feeling%20it%20would%20be%20something%20like%20this%2C%20but%20hoped%20maybe%20there%20was%20one%20weird%20trick%20I%20was%20missing!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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 it as geographical data.

 

I've tried both with setting the data as geographical and tying it to the correct entry, and as just plain text.

 

I've tried including Country/State as additional columns, but still no luck.

 

Any assistance would be greatly appreciated.

 

Thanks,

 

Emlyn

2 Replies
Highlighted
Best Response confirmed by ebreese (New Contributor)
Solution

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.

Highlighted

@Ingeborg Hawighorst 

 

Thanks Ingeborg, I had a feeling it would be something like this, but hoped maybe there was one weird trick I was missing!