I want to ask a client for addresses of employees by zipcode, not revealing home addresses. Ideally, Id collect the data by asking the client for an XL file with a single field: zipcodes for each person, which I assume they'd generate from a more complete person by person list, deleting columns that ID their employees' personal data, leaving only the zipcode column. Then I want to plot each employee with dots on a map by their zipcodes, with multiple dots in a single zipcode if more than one employee lives there. I cant figure out how to use zipcodes as data points. The final product would be simple, just a plain map with lots of dots. Can someone help? Thanks.
