Plotting a contour plot with excel data
10 views (last 30 days)
Show older comments
Hello everyone,
I want to plot a contour plot with the attached excel data. So the colour bar on the right needs to be the RH. The x axis is basially the first column L which is relative to R1......R13. For exaomple 1*R, 2*R. The different initial R should be on the y-axis. How do I best do this?
Thanks in advance
0 Comments
Accepted Answer
Sudheer Bhimireddy
on 12 Aug 2020
doc readmatrix
Import your data into a 2D array and then decide what columns you want to plot using contourf
12 Comments
Sudheer Bhimireddy
on 13 Aug 2020
Ah, now I understood your data.
Try this:
data = xlsread('Book2.xlsx');
R = data(1:14,16); % <- Got your R
% Initialize matrices
L = zeros(21,14);
R1 = zeros(21,14);
RH = zeros(21,14);
for i = 1:size(L,1)
L(i,:) = (i-1)*R;
R1(i,:) = R;
RH(i,:) = data(i,14);
end
contourf(L,R1,RH);
c=colorbar;
xlabel('L');ylabel('R');ylabel(c,'RH');
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/345759/image.png)
More Answers (0)
See Also
Categories
Find more on Contour Plots in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!