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))

Categories

Find more on Data Import and Analysis 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!