Colour coding points on a map

[DarrenrWood]

I feel really silly as I don't even know the correct terminology to use at this stage ! I have a spreadsheet in Google Maps that feeds data through to Esri which then plots locations onto the map ( based on Long/Latt in the sheet ).

I can see how to change the colour of the points on the map, but how do I set the colour based on another column of data in the spreadsheet. In practice I am plotting addresses and then want to colour code them according to their stage in the order process. this might be "enquiry" "signed up" "order despatched" etc. Different coloured points for different stages.

Ive found various posts talking about symbology, but my screen doesnt seem to offer the options that the instructions are telling me to do

I don't do any kind of programming so Im hoping this is a feature that is available. 

Im using Map viewer and Dashboard  

[fjramos]

I'm not sure how the spreadsheets are intepreted in AGOL Map Viewer, but for created feature layers you would set it up by a 'Field' under the Styles tab. I'll share an example of how it's done on feature layers, hopefully it's  not to different for spreadsheets.

Here is where you would add the field that controls the status. (In your case "Order Process"), but in mine it would be "Subtypecode" for my Pole feature layer.

Select style options "Types (unique symbols)". Here you will be able to adjust the points size, color, shape, etc. based on the list of the status of that field (Yours "Order Process", mine in this example is "Subtypecode"):

If the list does not appear, see if you can access the data in AGOL to get to the fields.

For my example, on the Pole feature layer fields, I use 'Subtypecode' as the field that will determine the color/symbology. I have assgigned a list of different options under the 'Subtypecode' (Yours would be "Order Process").  Select "Fields":

There will be a "Create List" on the ltop left in the Fields tab:

Create list:

List created in 'Subtypecode' field of  Pole feature layer:

Then go back to AGOL Map Viewer, repeat the first steps and see if the '+ Field' option recognizes the list for that field. Hope it helps.