i want plot 100 sheets of excel data in one plot. in each sheet number of column's are same and i want to plot 3rd column on Y axis and the cycle(sheet number) on y-axis.

here i want to plot charging data set of battery as i have 100 sheets of data each sheet represents a cycle of battery i want to plot voltage vs cycle graph of 100 cycles please help me how to do this.

[Cris LaPierre]

Definitely doable. Please share your code so we can help you.

Answer 1

[KSSV]

file = 'filename.xlsx' ; 
[status,sheets] = xlsfinfo(file) ; 
N = length(sheets) ; 

figure
hold on
for i = 1:N
    fprintf('Reading sheet : %s\n',sheets{i}) ; 
    T = readtable(file,'sheet',sheets{i}) ; 
    v = T.(1) ;
    c = T.(2) ; 
    plot(v,c)
end