Plot 3 axis from Excel
3 views (last 30 days)
Show older comments
Dears
How to plot data from attachment.
X axis 10-75
Y axis 10-75
Z axis (horizontal) 0-30000
3 Comments
dpb
on 17 Sep 2022
"row [1, values] 10-75 on the top is temperature goes into the heat exchanger"
"column [1, values] 10-75 is temperature comes out from heat exchanger"
-dpb
Answers (1)
dpb
on 17 Sep 2022
Edited: dpb
on 17 Sep 2022
Q=readmatrix('https://www.mathworks.com/matlabcentral/answers/uploaded_files/1127410/Heat%20exchange.xlsx');
Tin=Q(1,2:end);Tout=Q(2:end,1);Q=Q(2:end,2:end);
surf(Tin,Tout,Q)
hAx=gca;
hAx.View=[-60 40];
xlabel('T_{in}');ylabel('T_{out}');zlabel('Q')
NOTA BENE: Must take the 'Z' data from the overall array read ignoring the first row/column to matchup the actual 'X,Y' vector lengths from the whole array read in that has them all smooshed together. That's the only "trick" here.
It was very confusing to read the description owing to the language issues -- thought were describing that 10 rows/columns were all X, Y values until actually opened the spreadsheet to look -- the image @Image Analyst posted was so small couldn't read it ... :)
8 Comments
dpb
on 20 Sep 2022
MATLAB doesn't have a builtin multivariate Pareto distribution/plot in the base product; whether it has in another toolbox I don't know.
See Also
Categories
Find more on Axis Labels 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!