So I am making a map of fishing intensity. Currently, I have an excel table with the mid-latitude and mid-longitude for each of my intensity data points. I also have the c squared value for each point on my map. As the long/lat data is the centre of each point, I want to create square polygons around this point. I am using ArcGIS Desktop 10.6.1 with an Advanced licence.
I am able to input this data as a point shapefile no problem (via add xy data), but I want to be able to show this map as a relative intensity scale using graduated colours. I can kind of do this with points, but they slightly overlap each other and it doesn't look too great (see image).
How can I either put this type of data in as a polygon from excel or convert my point shapefile to a polygon shapefile?
I have tried aggregate points, but it doesn't work as I don't know the distance between my points in their long/lat form. I remember being able to do this a few months ago in class, to get the figure below, but I've stupidly lost the polygon shapefile for it!
cell_assignment = 'SUM'