Mapping group of zip codes

%3CLINGO-SUB%20id%3D%22lingo-sub-2771574%22%20slang%3D%22en-US%22%3EMapping%20group%20of%20zip%20codes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2771574%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20accounts%20with%20sales%20territories%20based%20on%20zip%20codes.%20I%20already%20have%20all%20the%20zip%20codes%20in%20their%20range%20for%20each%20account.%20Is%20there%20a%20way%20to%20map%20out%20each%20account's%20territory%3F%20More%20specifically%2C%20is%20there%20a%20way%20to%20see%20what%20territories%20overlap%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2771574%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2781948%22%20slang%3D%22en-US%22%3ERe%3A%20Mapping%20group%20of%20zip%20codes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2781948%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1162509%22%20target%3D%22_blank%22%3E%40crimsafemarketing%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CH3%20id%3D%22toc-hId--2146712416%22%20id%3D%22toc-hId-2147327664%22%3E1.%20Set%20the%20data%3C%2FH3%3E%3CP%3EOpen%20your%20Excel.%20Enter%20your%20data%20into%20the%20spreadsheet%20with%20ZIP%20codes%20and%20values%3B%20write%20them%20or%20copy%20from%20somewhere%20and%20paste.%3C%2FP%3E%3CP%3EIf%20you%20prefer%20to%20do%20that%20with%20geography%20data%20type%3B%20input%20your%20data%20which%20includes%20geographical%20values%2C%20then%20go%20to%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EData%20%26gt%3B%20Data%20Types%20%26gt%3B%20Geography%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22JulianoPetrukio_0-1632489389766.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F312669i17ADE347C4D8AA45%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22JulianoPetrukio_0-1632489389766.png%22%20alt%3D%22JulianoPetrukio_0-1632489389766.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EYour%20data%20will%20be%20converted%20into%20a%20geography%20data%20type.%20You%20can%20then%20add%20columns%20to%20the%20data%2C%20like%20population%20or%20tax%20rate.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CH3%20id%3D%22toc-hId-340800417%22%20id%3D%22toc-hId-339873201%22%3E2.%20Create%20the%20map%20chart%3C%2FH3%3E%3CP%3EOnce%20you%20finish%20arranging%20your%20data%2C%20select%20the%20cells%20you%20want%20to%20turn%20into%20the%20map.%3C%2FP%3E%3CP%3EThen%20on%20the%20Insert%20tab%2C%20go%20to%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3ECharts%20%26gt%3B%20Maps%20%26gt%3B%20Filled%20Map%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22JulianoPetrukio_1-1632489417803.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F312670iA01D18B190E2A393%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22JulianoPetrukio_1-1632489417803.png%22%20alt%3D%22JulianoPetrukio_1-1632489417803.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20Excel%20reads%20the%20ZIP%20codes%20you%20entered%20and%20creates%20a%20map%20chart%20based%20on%20them.%20Relatively%20low%20values%20are%20represented%20by%20light%20colors%20and%20higher%20values%20are%20shown%20with%20darker%20colors.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22JulianoPetrukio_2-1632489444989.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F312671iF0A20DA29FCC01EE%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22JulianoPetrukio_2-1632489444989.png%22%20alt%3D%22JulianoPetrukio_2-1632489444989.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have accounts with sales territories based on zip codes. I already have all the zip codes in their range for each account. Is there a way to map out each account's territory? More specifically, is there a way to see what territories overlap?

1 Reply

@crimsafemarketing 

I would suggest you to provide some sample of your data.

Because depending how it is organised, you can use just a MATCH() formula to get the groups.

1. Set the data

Open your Excel. Enter your data into the spreadsheet with ZIP codes and values; write them or copy from somewhere and paste.

If you prefer to do that with geography data type; input your data which includes geographical values, then go to Data > Data Types > Geography.

 

JulianoPetrukio_0-1632489389766.png

Your data will be converted into a geography data type. You can then add columns to the data, like population or tax rate.

 

2. Create the map chart

Once you finish arranging your data, select the cells you want to turn into the map.

Then on the Insert tab, go to Charts > Maps > Filled Map.

JulianoPetrukio_1-1632489417803.png

 

Here Excel reads the ZIP codes you entered and creates a map chart based on them. Relatively low values are represented by light colors and higher values are shown with darker colors.

 

JulianoPetrukio_2-1632489444989.png