MATLAB: How to make a color-map from lat long and data.

Question

I have an excel file which has 3 coloumns longitude,latitude and data.I want to make a colormap.How can I do that.I am attaching the data file and a picture which shows what I want to do.

Answer 1

try this

data = readmatrix('data.xlsx');
lat = data(:,1);
lon = data(:,2);
val = data(:,3);
latV = linspace(min(lat), max(lat), 100);
lonV = linspace(min(lon), max(lon), 100);
[latG, lonG] = meshgrid(latV, lonV);
valG = griddata(lat, lon, val, latG, lonG);
contourf(latG, lonG, valG, 100, 'LineColor', 'none')
colormap(jet)
colorbar