ABC and XYZ Analysis on one Graph

Ubaid ur Rahman

Dear friends,


I have a question regarding plotting ABC and XYZ on one graph.

I have search a lot but could not get it. 

Could you please help in this regard?


Details are in the attached file there I explained what I need.


Thanks in advance!

2 Replies

Hi Ubaid,


I guess before plotting the chart the table shall be transformed into ABC-XYZ, sample is here https://exceltable.com/en/analyses-reports/abc-xyz-analysis-in-excel

ok thank you Sergei!