How can i draw a color map from spread sheet in excel? In excel, I have the second attached figure where x=wave length,y=Abs., and legend = doping conc. I want to draw them like the attached color map. attached image from excel shows the data

<<pic>>

Answer 1

[Image Analyst]

This code will make that red, white, and blue patriotic colormap:

numColors = 256;
ramp = linspace(0, 1, numColors/2)';
rampFlipped = linspace(1, 0, numColors/2)';
flat = ones(numColors/2, 1);
redColorMap = [flat; rampFlipped];
greenColorMap = [ramp; rampFlipped];
blueColorMap = [ramp; flat];
blueRedColorMap = [redColorMap, greenColorMap, blueColorMap];
colorbar();
colormap(blueRedColorMap);

[mai desouky]

How can i redefine the matrix ( which is attached in that form in the excel figure) such that the matlab draws it exactly as in the color map figure? In fact my main problem is i can not write the code for the table to convert it to such matrix. where x=wave length, y =doping Nd and the variable/color bar is the absorption from 0-1.

[Image Analyst]

The data in the workbook defines curves where there is just one value for one wavelength - not a bunch of values for a wavelength which would be an image. These curves seem to be shown over the image as faint curves. They seemed to somehow use all three 1-D curves in building the 2-D image. I have no idea how they did that. You'll have to ask someone else.