Data extraction from stacked plot

I want to extract data from the stacked plot generated , by extracting data i mean that whenever the user clicks on the staked plot , a set of values are displayed at the intersection of the plot and vertical line ( please refer to the figure to get more understanding of what i mean) , i want to extract these values and then write them to an excel sheet . Please help me to do that.

( I want the values displayed in the boxes to be written in an excel file )

Thank you.

Answer 1

[ANKUR KUMAR]

Let us load random data.

tbl = readtable('patients.xls');
stackedplot(tbl,{'Height','Weight','Systolic','Diastolic'})

There must be value of x over which you wish to extarct all the values. Let us take 50 in this case.

values=[tbl.Height tbl.Weight tbl.Systolic tbl.Diastolic];
values_x=1:size(values,1);
extracted_values=values(values_x==50,:)

extracted_values = 1×4

67 179 124 78

[Ajai Singh]

Thank you for the answrer. appreciate it, but can i get the value of x when the user clicks on the stacked plot ?