Hi all, I am trying to show categorical data with XY coordinates from an excel file (I have the ID column, 2-3 columns with the categorical data and the XY columns) in a GIS map. I have added my spreadsheet in gis, I right-clicked Display XY data, I could see all the points with one colour. But when I went to symbology-categories-specify the field with the categorical data-add all values, I changed the colour and size for each category (however there was a question mark in the count column) and Apply nothing happened. It was still one colour. I tried to open the attribute table but it was blank.
Could you please help me?
Thank you in advance.
can you post a small portion of your table ... perhaps there is an issue with your data types
also, you have posted your question in GeoNet help... which is about help on using GeoNet. I might suggest that you move your post to Managing Data Managing Data
The community structure is here GeoNet Community Structure
Here is a sample of my data; I have as well formatted the 'super' column which has my categorical data as text.
If you used Unique Values for your super column as shown here
then there shouldn't be an issue, assuming you added all the categories to the legend . then keep pressing Ok, apply, Ok to see the results...don't work about the count field just yet.
I would also recommend fine-tuning the colours AFTER you have the correct symbology applied first...not during the process...no point in wasting time if the base classification isn't going to work in the first place.
<all other values>.... is the values that aren't in the classification scheme. If you have done it correctly, you should have a colour beside your super letters... A, B...E since that is the classified data. Check the link I sent and/or look onscreen. PS nothing is going to change until you OK your way out to the end and make the symbology apply to the map
Ok... you are losing me..I can't see what you aren't seeing so if you have done the symbology correct you should have a legend in the table of contents representing the various classes...if you don't it is scrreen grab time to show what is going on
so they are points and you appear to be in data view, now when you go back to the dataframe, right-click on that layer and select zoom to layer... the dots should appear If they don't, insert a new dataframe and add just that file. It would also be best to convert that event layer to a featureclass or shapefile and ensure it has a defined projection... this should be done way before symbology is handled