Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have an excel file with 2 attribute columns, 1-feature info 2-Number of color (RGB) that the current feature should be symbolize. This file file can be joined with the layer using the "feature info" field which is unique (join by attribute table). So i have as attribute the color number attribute for every polygon feature.

How can i use this this information to symbolize every feature with their attributed color already imported from the excel sheet?

share|improve this question
This question is similar to the unanswered – PolyGeo Nov 26 '14 at 20:57
I've seen several variations of this question here. To my knowledge there is no way to symbolize a vector layer using pure RGB values. You'd have to first build it into a lyr file, feature template, or cartographic representation, and then use that. And I'm not aware of a way to automatically build/convert any sort of table of values into one of those. See also: (no answer). – Chris W Nov 26 '14 at 21:12
You could do it in .net but I'm fairly sure that's the only way. It would be a HUGE UniqueValueRenderer for features or create graphics for each feature using the table colour... it just depends on what you want to do with it. – Michael Miles-Stimson Nov 26 '14 at 21:29
yes, its a big list already standardized from a previous person, i now need to follow that craziness. – Shefqet LULJA Nov 26 '14 at 21:42

As mentioned in comments, I am not aware of any out-of-the-box way for ArcMap to symbolize layers using RGB values stored in an attribute table, or using RGB values in Excel joined onto an attribute table.

However, there is an existing ArcGIS Idea to Set symbol color from RGB values in attribute table so I recommend that you add your vote to that.

Note that the above ArcGIS Idea only covers:

The ability to set the fill colour for a symbol from RGB values stored in the attribute table of a shapefile/feature class.

So if you are wanting to do this for points, polylines or outlines of polygons then you may want to submit additional or more comprehensive ArcGIS Ideas.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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