I am not getting a linear plot, how can I get a plot that consist all the data points?

3 次查看（过去 30 天）
Manav Divekar
Manav Divekar 2022-6-7
评论： Star Strider 2022-6-7
I want to plot from the excel sheet from table F1:I31 but the matlab is not taking all the data and plotting. the does not seem correct
dataset = xlsread('Problem1.xlsx','Sheet1','F1:I31');
x = dataset(:,2);
y = dataset(:,3);
z = dataset(:,4);
figure
plot(x,y,'r');
xlabel('time');
ylabel('displacement');
title('U1');
figure
plot(x,z);
xlabel('time');
ylabel('displacement');
title('U2');

请先登录，再回答此问题。

采纳的回答

Star Strider
Star Strider 2022-6-7
Ran in:
You are asking it to read 30 rows across 4 columns, and it is doing exactly that —
T1 = readtable('https://www.mathworks.com/matlabcentral/answers/uploaded_files/1024315/Problem1.xlsx','Sheet',1, 'Range','F1:I31', 'VariableNamingRule','preserve')
T1 = 30×4 table
Time Step Number counter Time(t+deltat) U1 at (t+delta) U2 at (t+delta) ________________________ ______________ _______________ _______________ 1 21 2205 0 2 42 7.7792e+06 -1.4586e+06 3 63 2.9364e+10 -6.4312e+09 4 84 1.1217e+14 -2.5106e+13 5 105 4.2811e+17 -9.6175e+16 6 126 1.6364e+21 -3.6777e+20 7 147 6.2694e+24 -1.4087e+24 8 168 2.3973e+28 -5.3883e+27 9 189 9.1754e+31 -2.0619e+31 10 210 3.5094e+35 -7.8853e+34 11 231 1.342e+39 -3.0161e+38 12 252 5.1243e+42 -1.1522e+42 13 273 1.9574e+46 -4.3988e+45 14 294 7.493e+49 -1.6837e+49 15 315 2.8632e+53 -6.433e+52 16 336 1.0935e+57 -2.4577e+56
dataset = table2array(T1);
x = dataset(:,2);
y = dataset(:,3);
z = dataset(:,4);
figure
plot(x,y,'r');
set(gca, 'YScale','log') % <— ADDED
xlabel('time');
ylabel('displacement');
title('U1');
figure
plot(x,z);
set(gca, 'YScale','log') % <— ADDED
xlabel('time');
ylabel('displacement');
title('U2');
To get a plot that appears to be linear, plot the logarithm of the dependent variable.
.

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Annotations 的更多信息

标签

产品


版本

R2021b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by