Plot 3 axis from Excel
显示 更早的评论
Dears
How to plot data from attachment.
X axis 10-75
Y axis 10-75
Z axis (horizontal) 0-30000
3 个评论
Image Analyst
2022-9-17
编辑：Image Analyst
2022-9-17
Exactly what do the rows and columns in your matrix mean? Which row or column is x, which is y, and which is z???
Maciej
2022-9-17
dpb
2022-9-17
"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
回答（1 个）
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 个评论
Maciej
2022-9-18
dpb
2022-9-18
SOMETHING must've happened -- an error message, something...
Only change you should need to make would be to use your local file name inplace of the link to the uploaded copy online.
We'd have to see the whole command session to be able to comment further...
Maciej
2022-9-18
That appears to be an issue with your default language/character set -- MATLAB is complaining that it can't read the filename string with bidirectional unicode characters.
I've never run across them before; know nothing about such animals with languages other than English so I'm not sure how one would go about fixing the issue on such a system.
How did you create the text string in the image -- since it was attached as an image and not as the text, we can't see what the actual code bytes are; see what
FQN=....; % paste the filename string in your readmatrix command here
double(FQN(1:10)) % see what the ASCII codes of the first 10 characters are
If just mimic the beginning get
FQN='C:\Users\inzma\...';
double(FQN(1:10))
where '67' is the ASCII code for single quote. If you don't get that try
FQN=strrep(FQN,char(XX),char(67));
where 'XX' would be the value you see other than 67 (presuming see something different) as first value of the filename. Then retry the code with the patched filename and see what happens.
How did you create the file name above???
Maciej
2022-9-19
dpb
2022-9-19
Indeed, that would be expected result.. :)
I had intended to specifically menton you needed to resave the file with the corrected filename w/o the bidirectional unicode characters in it -- or to make sure if the actual filename didn't contain the characters, the filename string were using didn't...
As noted, I've no experience with such, so not sure just what is/isn't supposed to be supported or how...
Maciej
2022-9-20
dpb
2022-9-20
MATLAB doesn't have a builtin multivariate Pareto distribution/plot in the base product; whether it has in another toolbox I don't know.
类别
在 帮助中心 和 File Exchange 中查找有关 Creating, Deleting, and Querying Graphics Objects 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
