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.