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

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

[dpb]

Have you looked at

doc readtable
doc pareto

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

[Sarath J]

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';
   2  25  'CDE';
   3  22  'BTS';
   4  10  'RSD';
   5  5  'TSE';
   6  4  'DMP';
   7  3  'MTR';
   8  1  'BAC';
   9  1  'BAD'];

Answer 1

[dpb]

A={1  30  'ARD';
   2  25  'CDE';
   3  22  'BTS';
   4  10  'RSD';
   5  5  'TSE';
   6  4  'DMP';
   7  3  'MTR';
   8  1  'BAC';
   9  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.

[Sarath J]

Thank you very much DB. Appreciate your help and advise.