Here's one way.
For importing data, perhaps something like data=transpose(readmatrix('filename.xlsx',Range','A2:N2002'));
Empty cells should be imported as NaNs then.
% Generate fake data
data = 2*rand(14,120);
for idx = 1:14
data(idx,1:randi(70)) = nan;
end
% Plot it, beginning at year 1901
xx = 1900+[1:size(data,2)];
interestingPlot(xx,data)
function interestingPlot(xx,data)
yy = 1:size(data,1);
f = pcolor(xx,yy,data);
shading flat
colorbar
% Shift the bins
f.XData = f.XData-.5;
f.YData = f.YData-.5;
ax = gca;
% Shift the axes
ax.XLim = ax.XLim-.5;
ax.YLim = ax.YLim-.5;
% Flip the y axis
ax.YDir = 'reverse';
xlabel('Date')
ylabel('Site')
colormap (flipud(hot))
end
