Home

Pareto Chart - other column problem

%3CLINGO-SUB%20id%3D%22lingo-sub-679954%22%20slang%3D%22en-US%22%3EPareto%20Chart%20-%20other%20column%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-679954%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20want%20to%20make%20a%20pareto%20chart%20and%20I%20have%20some%20data%20with%20one%20column%20showing%20category%20and%20other%20values.%20But%20I%20want%20to%20put%20the%20rows%20with%20value%20greater%20than%2085%25%20in%20OTHER%20column.%20The%20sum%20of%20the%20OTHER%20column%20is%20greatest%20among%20all%20so%20it%20is%20appearing%20as%20the%201st%20bar%20but%20i%20want%20it%20at%20the%20last.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20how%20to%20make%20it%20dynamic%20i.e.%20how%20it%20will%20automatically%20put%20rows%20with%20value%20greater%20than%2085%25%20in%20OTHER%20column.%3C%2FP%3E%3CP%3EAnd%20do%20I%20have%20to%20write%20any%20macro%20for%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-679954%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-686600%22%20slang%3D%22en-US%22%3ERe%3A%20Pareto%20Chart%20-%20other%20column%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-686600%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F357336%22%20target%3D%22_blank%22%3E%40manan2340%3C%2FA%3EPareto%20chart%20principle%20is%20based%20on%20sorting%20from%20the%20largest%20to%20smallest%2C%20I%20think%20it%20will%20bot%20be%20the%20solution%20of%20your%20case.%3C%2FP%3E%3CP%3EYou%20may%20use%20the%20Pie%20of%20Pie%20chart%20or%20Bar%20of%20Pie%20chart%2C%20these%20two%20types%20contain%20an%20option%20to%20handle%20the%20%22Other%22%20item%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20537px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F117879i3CC91609EA5DE2DF%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22barofpiepieofpie.jpg%22%20title%3D%22barofpiepieofpie.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-686742%22%20slang%3D%22en-US%22%3ERe%3A%20Pareto%20Chart%20-%20other%20column%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-686742%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F31577%22%20target%3D%22_blank%22%3E%40Ayman%20Hassan%3C%2FA%3E%26nbsp%3BHi%2C%20I%20will%20try%20it.%20Thank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E
manan2340
New Contributor

Hi, I want to make a pareto chart and I have some data with one column showing category and other values. But I want to put the rows with value greater than 85% in OTHER column. The sum of the OTHER column is greatest among all so it is appearing as the 1st bar but i want it at the last.

 

And how to make it dynamic i.e. how it will automatically put rows with value greater than 85% in OTHER column.

And do I have to write any macro for it?

 

Thank you in advance.

2 Replies

@manan2340Pareto chart principle is based on sorting from the largest to smallest, I think it will bot be the solution of your case.

You may use the Pie of Pie chart or Bar of Pie chart, these two types contain an option to handle the "Other" item problem.

 

 

 

barofpiepieofpie.jpg

@Ayman Hassan Hi, I will try it. Thank you.

Related Conversations