Home

Excel map data issue

%3CLINGO-SUB%20id%3D%22lingo-sub-659769%22%20slang%3D%22en-US%22%3EExcel%20map%20data%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-659769%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone!%3C%2FP%3E%3CP%3EI'm%20having%20issues%20mapping%20data.%20I%20have%20sales%20data%20for%20each%20postcode%20in%20Queensland%2C%20Australia%20that%20I%20want%20to%20map.%20When%20I%20try%2C%20however%2C%20it%20shows%20the%20whole%20world%20and%20it%20is%20very%20hard%20to%20see%20my%20data.%20I%20have%20tried%20showing%20just%20the%20postcodes%20with%20data%20in%20the%20chart%20area%2C%20but%20it%20doesn't%20zoom%20in%20to%20Queensland%20and%20just%20shows%20a%20mainly%20blank%20chart.%20I've%20tried%20renaming%20Postal%20Code%20to%20Postcode%20and%20Zip%20Code%20but%20no%20difference%2C%20and%20I've%20also%20tried%20including%20the%20regions%20which%20the%20postcodes%20are%20in%20but%20this%20doesn't%20change%20the%20display%20at%20all.%3C%2FP%3E%3CP%3EPlease%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-659769%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Mariah_M
Visitor

Hi everyone!

I'm having issues mapping data. I have sales data for each postcode in Queensland, Australia that I want to map. When I try, however, it shows the whole world and it is very hard to see my data. I have tried showing just the postcodes with data in the chart area, but it doesn't zoom in to Queensland and just shows a mainly blank chart. I've tried renaming Postal Code to Postcode and Zip Code but no difference, and I've also tried including the regions which the postcodes are in but this doesn't change the display at all.

Please help!

Related Conversations