Making a plot to find out when, during a 24 hour period, two rows in excel has the same value.
3 views (last 30 days)
Show older comments
Hello
I have two rows of data in excel that was recorded on two seperate days with a sample time of 6 seconds, as seen in the image below. I was wondering if there's a way to plot a graph in matlab, with 24 hours and sample time of 6 seconds on the x-axis, so that I can see when the data from the two days intersects and have the same value.
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/202995/image.png)
0 Comments
Answers (1)
Bob Thompson
on 6 Feb 2019
Edited: Bob Thompson
on 6 Feb 2019
Do you specifically need to plot the results? Why not just use logic indexing?
t = data(:,ismember(data(:,2:3,1),data(:,2:3,2)),1); % Note that I assumed your
% data was put in a 3D array
% called 'data' which
% contains your image as the
% first
% and second dimensions,
% with each day as the third
% dimension.
% Modify as needed.
0 Comments
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!