I have a shapefile and a separate excel Sheet.

I want this shapefile to interact with the excel sheet. I have assigned numbers associated with colors on this sheet, what I would like to do is have the shape color change with the numbers in the excel sheet.

I believe this is something I can accomplish in ArcGIS 10 ModelBuilder but I don't know how to go about it.

  • what is the relationship between the features in your shapefile to the rows in your spreadsheet? Is there a matching field? – Midavalo May 3 '16 at 7:20
  • there is a matching field, but the matching field is a name – Joe May 3 '16 at 8:00
  • By numbers do you mean RGB values or something else? – PolyGeo May 3 '16 at 9:37
  • The numbers in the spread sheet are 1-5. Not RGB. The numbers are used in criminality statistics. For Example: Chicago has an extremely high crime rate, so the number assigned to the excel sheet is 5. In Belleville, Ill, the crime is low so the number assigned is 1. The excel sheet has the information I need to assign areas colors. – Joe May 3 '16 at 9:44
  • 1
    @PolyGeo sounds more like a symbolise by attribute value through an excel join – Midavalo May 3 '16 at 18:08

This is a slightly different way of doing this, but you can do this with the ArcGIS Maps for Office add-in.

I downloaded some crime stats and made a map out of it very quickly: enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.