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
Deleted
Not applicable

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

@DeletedPareto 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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies