Adding Legends to multiple lines in an x-y plot of data imported from Excel sheets in MATLAB ?

2 次查看（过去 30 天）

显示更早的评论

Ahmad Bilal 2018-10-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/422786-adding-legends-to-multiple-lines-in-an-x-y-plot-of-data-imported-from-excel-sheets-in-matlab

编辑： madhan ravi 2018-10-11

采纳的回答： madhan ravi

在 MATLAB Online 中打开

Hi, I have the following code:

[~,sheets] = xlsfinfo('C:\Users\Bilal Ahmad\Desktop\Complete Simulations\Microphone Array 1_AllSources\AllSource_MicArr1.xlsx');
for i = 1:length(sheets)
data{i} = xlsread('C:\Users\Bilal Ahmad\Desktop\Complete Simulations\Microphone Array 1_AllSources\AllSource_MicArr1.xlsx',sheets{i},'A4:T6');
d = data{i}(:,7);
tau_g = data{i}(:,9);
plot(d,tau_g,'-x');
hold all
grid on
xlabel('distance d b/w mic pairs[cm]');
ylabel('\tau_g_r_o_u_n_d');
title('Relationship between \tau ground and distance between Mic Pairs for Array 1');
end

when i run this code. i get a following plot

Now, As it is clear in this plot that i am getting data from 16 different sheets that belongs to 16 different sources. My problem is I want to show labels to each 16 different lines so that i come to know which line belong to which sheet of data? Can anybody help me in this regard. Thank you

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

采纳的回答

madhan ravi 2018-10-8

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/422786-adding-legends-to-multiple-lines-in-an-x-y-plot-of-data-imported-from-excel-sheets-in-matlab#answer_340294

编辑：madhan ravi 2018-10-8

在 MATLAB Online 中打开

 Legend=cell(16,1)
 for iter=1:16
Legend{iter}=strcat('sheet', num2str(iter));
 end
 legend(Legend)

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

Ahmad Bilal 2018-10-8

My question is how can i fit this code in the above mentioned code because when I tried it shows an error : index exceeds matrix dimensions

madhan ravi 2018-10-8

编辑：madhan ravi 2018-10-8

Which line shows error , your question is vague.

请先登录，再进行评论。

更多回答（2 个）

Ahmad Bilal 2018-10-8

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/422786-adding-legends-to-multiple-lines-in-an-x-y-plot-of-data-imported-from-excel-sheets-in-matlab#answer_340340

在 MATLAB Online 中打开

Hi this is my now updated code.

[~,sheets] = xlsfinfo('C:\Users\Bilal Ahmad\Desktop\Complete Simulations\Microphone Array 3_AllSources\AllSrc_MicArray3.xlsx');
for i = 1:length(sheets)
data{i} = xlsread('C:\Users\Bilal Ahmad\Desktop\Complete Simulations\Microphone Array 3_AllSources\AllSrc_MicArray3.xlsx',sheets{i},'A4:T8');
d = data{i}(:,7);
tau_g = data{i}(:,9);
   hold all
   grid on
   Legend = cell(16,1);
  for iter = 1:16
     Legend{iter} = strcat('source', num2str(iter));
  end
 legend(Legend)
    lineColor = {'k', 'r', 'b', 'm'};
     linestyle = {'-'; '--'; ':'; '-.'};
  for j = 1:4
      options = {'color',lineColor{j}, 'LineStyle', linestyle{j}};
    plot(d(:,j), tau_g(:,j), options{:})
  end
    xlabel('distance d b/w mic pairs[cm]');
    ylabel('\tau_g_r_o_u_n_d');
    title('Relationship between \tau ground and distance between Mic Pairs for Array 3');
 end

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

madhan ravi 2018-10-8

Ofcourse gimme sometime , will get back after a work.

Ahmad Bilal 2018-10-8

Thank you so much. I will wait for your answer

请先登录，再进行评论。

madhan ravi 2018-10-8

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/422786-adding-legends-to-multiple-lines-in-an-x-y-plot-of-data-imported-from-excel-sheets-in-matlab#answer_340347

编辑：madhan ravi 2018-10-8

在 MATLAB Online 中打开

[~,sheets] = xlsfinfo('C:\Users\Bilal Ahmad\Desktop\Complete Simulations\Microphone Array 3_AllSources\AllSrc_MicArray3.xlsx');
lineColor = {'k', 'r', 'b', 'm','c','g','k','y','r','g','m','c','y','b','k','g'};
     linestyle = {'-'; '--'; ':'; '-.';'-x';':';'-^';'->';'-v';'-s';'-p';'--';'-x';'-s';'-p';'--x'};
    Legend = cell(16,1);
for i = 1:length(sheets)
data{i} = xlsread('C:\Users\Bilal Ahmad\Desktop\Complete Simulations\Microphone Array 3_AllSources\AllSrc_MicArray3.xlsx',sheets{i},'A4:T8');
d = data{i}(:,7);
tau_g = data{i}(:,9);
   hold all
   grid on
     Legend{iter} = strcat('source', num2str(iter));
         options = {'color',lineColor{j}, 'LineStyle', linestyle{j}};
    plot(d, tau_g, options{:})
    xlabel('distance d b/w mic pairs[cm]');
    ylabel('\tau_g_r_o_u_n_d');
    title('Relationship between \tau ground and distance between Mic Pairs for Array 3');
 end
 legend(Legend)