Two graphs in the same plot, why?

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

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

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.

Categories

Find more on MATLAB in Help Center and File Exchange

Products

Release

R2023b

Asked:

on 31 Jan 2024

Commented:

on 31 Jan 2024

Community Treasure Hunt

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

Start Hunting!