We are trying to help the county health department make a map of radon exposure at houses throughout the county. We are using ArcMap 10.1 with all extensions.
They sent us an excel spread sheet with 3 relevant fields: (1) lat & (2) long in decimal degrees and (3) exposure concentrations. We want to convert the data in the table to points, then symbolize by the concentration. So far we have been able to get points in ArcMap by using the 'Display x y data' button but when we bring in the county map, the dots are far away from the county. Also, this resulting set of points has no attribute table to symbolize from.
Is there a straightforward way to take data from an excel table and give it functionality in ArcMap?
Thanks for reading.