9

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

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

0

1 Answer 1

2

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.


Alternatively, if you use ArcGIS Pro, you can use a few lines of ArcPy/Python to calculate a hexadecimal color field from your RGB values and then use attribute driven symbology.

For more details see Using RGB values stored in field of feature class to apply colour component for ArcGIS Pro symbology?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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