MATLAB Answers

How to plot only the available data?

2 views (last 30 days)
Ivan Mich
Ivan Mich on 7 Feb 2021
Answered: Walter Roberson on 7 Feb 2021
I have two columns. The second column has not all its data completed, and as a result with the use of command readcell there is an error in screen (1x1 missing). I wouls like to make a plot taking into account the avalaiable data of the file.
I am uploading the file.
Thank you in advance

Answers (1)

Walter Roberson
Walter Roberson on 7 Feb 2021
d = readmatrix('uest.xlsx');
d = rmmissing(d);
scatter(d(:,1), d(:,2))

Community Treasure Hunt

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

Start Hunting!