Two graphs in the same plot, why?

3 views (last 30 days)
Sergio
Sergio on 31 Jan 2024
Commented: Sergio on 31 Jan 2024
Hi, I imported some data from an xls file, and when plotting it , I obtain two graphs in the plot. Only one is necessary. What is the other and why does it appear?
xlsread('sunHoursInTrollhattan.xlsx')
plot(ans)
xlabel('måned')
ylabel('timer')
title('Soltimar i Trollhattan')
Thanks

Accepted Answer

Alan Stevens
Alan Stevens on 31 Jan 2024
Something like this
data = xlsread('sunHoursInTrollhattan.xlsx');
mins = data(:,1)*60 + data(:,2);
plot(1:12, mins,'o'),grid

More Answers (1)

Alan Stevens
Alan Stevens on 31 Jan 2024
You have the hours as one plot and the minutes as the other!
Turn the data into all minutes, or all hours first.
  1 Comment
Sergio
Sergio on 31 Jan 2024
Edited: Sergio on 31 Jan 2024
How can I do that? I tried
T=readtable('sunHoursInTrollhattan.xlsx',Range="A2:B13",ReadVariableNames=false)
ans=plot(T.Var1,T.Var2)
xlabel('Måned');
ylabel('Timar');
title('Soltimar i Trollhattan');
but that didn't work

Sign in to comment.

Products


Release

R2023b

Community Treasure Hunt

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

Start Hunting!