Hello; Can someone please help me matlab doesn't plot my excel data it show the axis only I am trying to make spectral analysis.i have attested the excel file and code as well.

1 次查看（过去 30 天）

arif hussain 2017-5-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/340249-hello-can-someone-please-help-me-matlab-doesn-t-plot-my-excel-data-it-show-the-axis-only-i-am-tryin

编辑： dpb 2017-5-17

filename = 'datacollect2.xlsx';
N = length(filename);
fs = 400; 
fnyquest = fs/2;
num = xlsread(filename);
 y = num(: ,2);
 mags = abs(fft(y));
bin_vals = [0 : N-1];
fax_Hz = bin_vals*fs/N;
N_2 = ceil(N/2);
plot(mags(1:N_2),fax_hz(1:N_2))
xlabel('Frequency (Hz)')
ylabel('Power (dB)');
title('Single-sided Power spectrum (Hertz)');
axis tight

5 个评论
显示 3更早的评论隐藏 3更早的评论

arif hussain 2017-5-16

yes the axis is appeared its empty but when I removed this line (fax_hz(1:N_2)) from the plot command its shows the complete spectral. No there is no any error.

arif hussain 2017-5-16

that is.PNG

here is the data file attached

请先登录，再进行评论。

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

采纳的回答

dpb 2017-5-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/340249-hello-can-someone-please-help-me-matlab-doesn-t-plot-my-excel-data-it-show-the-axis-only-i-am-tryin#answer_267116

编辑：dpb 2017-5-15

在 MATLAB Online 中打开

filename = 'datacollect2.xlsx';
N = length(filename);
fs = 400; 
fnyquest = fs/2;
num = xlsread(filename);
y = num(: ,2);
mags = abs(fft(y));
bin_vals = [0 : N-1];

Probably biggest problem is you've used the length of the filename as the length of the data. The file name is just that; the string containing the name of the file on the disk, it has nothing whatsoever to do with the data contained in the file.

Here,

>> filename = 'datacollect2.xlsx';
N = length(filename)
N =
  17
>>

so all you've plotted are the first 9 points out of the arrays; not much at all... :)

N = length(y);

after you've defined y will undoubtedly help a lot, particularly when you get the roles of X,Y corrected in the plot statement.

You may want to also plot 2*abs(fft(y))/N to normalize the spectrum amplitude to input. See

doc fft % example there shows some other details as well

3 个评论
显示 1更早的评论隐藏 1更早的评论

arif hussain 2017-5-16

编辑：dpb 2017-5-16

在 MATLAB Online 中打开

i dont think so this is accurate spectrum may be something wrong here.data file and code attested below.

filename = 'datacollect2.xlsx';
num = xlsread(filename);
fs = 400;
x = num(:,1);
N = length(x);
 y = num(: ,2);
 mags = abs(fft(y));
bin_vals = [0 : N-1];
fax_Hz = bin_vals*fs/N;
N_2 = ceil(N/2);
plot(mags(1:N_2),fax_Hz(1:N_2))