Color map plotting with weightage

Dear Experts,

I want to plot (x,y) with the circles associated with the weightage of y depends on the third column of excel sheet. The plot should look like the attached image. Color map will be appreciated.

[Adam]

Does

doc plot

not do the job?

Answer 1

[KSSV]

Read about scatter

[num,txt,raw] = xlsread('Book1.xlsx') ; 

x = num(:,1) ; 
y = num(:,2) ; 
w = num(:,3) ; 

plot(x,y)
hold on
% remove the nans 
idx = isnan(x) ; 
x(idx) = [] ; y(idx) = [] ; w(idx) = [] ;
scatter(x,y,w+20,w,'filled')     % 20 is added to 20, it can be changed