How can I plot a Pareto Chart (Y-axis= Qty VS. X-axis = Part Description) for the attached Excel data table?

Question

Sarath J 2018-9-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/418502-how-can-i-plot-a-pareto-chart-y-axis-qty-vs-x-axis-part-description-for-the-attached-excel-dat

编辑： Sarath J 2018-9-12

Pareto for Parts.xlsx

How can I plot a Pareto Chart (Y-axis= Qty VS. X-axis = Part Description) for the attached Excel data table? Thanks in advance. Sarath J

2 个评论
显示无隐藏无

dpb 2018-9-11

在 MATLAB Online 中打开

Have you looked at

doc readtable
doc pareto

? If so, where, specifically, did you find a problem?

Sarath J 2018-9-11

编辑：dpb 2018-9-11

在 MATLAB Online 中打开

image.png

I used to create a matrix from the table such as below and plot two columns of my X-Y choice, like Pareto(A(:,3), A(:,2)); This method worked well without text data in the table. For text data in a column wouldn't let me do it using the same way I used to do.

A=[1  30  'ARD';
25  'CDE';
22  'BTS';
10  'RSD';
5  'TSE';
4  'DMP';
3  'MTR';
1  'BAC';
1  'BAD'];

请先登录，再进行评论。

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

Answer 1

dpb 2018-9-11

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/418502-how-can-i-plot-a-pareto-chart-y-axis-qty-vs-x-axis-part-description-for-the-attached-excel-dat#answer_336382

在 MATLAB Online 中打开

A={1  30  'ARD';
25  'CDE';
22  'BTS';
10  'RSD';
5  'TSE';
4  'DMP';
3  'MTR';
1  'BAC';
1  'BAD'};
t=cell2table(A);
pareto(t.A2,t.A3)

seemed to work just fine. You can't put double numeric data and text together in an "ordinary" array with []; disparate data types must go into a cell array or table.