Data extraction from stacked plot

Question

Ajai Singh 2021-7-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/878673-data-extraction-from-stacked-plot

评论： Ajai Singh 2021-7-14

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.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

ANKUR KUMAR 2021-7-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/878673-data-extraction-from-stacked-plot#answer_746988

编辑：ANKUR KUMAR 2021-7-14

在 MATLAB Online 中打开

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