Home

Need assistance in creating a Pareto chart from a large data set

%3CLINGO-SUB%20id%3D%22lingo-sub-855920%22%20slang%3D%22en-US%22%3ENeed%20assistance%20in%20creating%20a%20Pareto%20chart%20from%20a%20large%20data%20set%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-855920%22%20slang%3D%22en-US%22%3E%3CP%3EGreetings%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20decent%20size%20set%20of%20data%20that%20I%20need%20to%20put%20into%20a%20Pareto%20chart.%20Ideally%2C%20I%20want%20to%20show%20the%20total%20delay%20time%20for%20the%20for%20the%20year%20based%20on%20the%20code%20in%20which%20the%20delay%20came%20from.%20Also%20if%20there%20is%20any%20possibility%20of%20me%20being%20able%20to%20filter%20the%20data%20going%20into%20the%20Pareto%20and%20add%20future%20data%20to%20the%20Pareto%20chart%20in%20an%20easy%20manner%20for%20updating%20purposes%2C%20I%20would%20be%20grateful%20to%20learn%20how.%20Also%20attached%20is%20a%20Pareto%20Template%20that%20I%20would%20like%20to%20base%20my%20filtering%20on%20(see%20the%202nd%20sheet%20%2212%20bar%20single%20graph%20%231%22%20as%20an%20example).%20This%20template%20allows%20me%20to%20filter%20the%20graphed%20data%20based%20on%20date%2C%20source%2C%20and%20areas.%20In%20the%20attached%20document%20%22Large%20Data%20Set%22%20I%20have%20a%20Pareto%20sheet%20created%20for%20the%20data%20that%20I%20would%20like%20to%20graph.%20Please%20let%20me%20know%20if%20you%20may%20need%20any%20further%20information%20to%20be%20able%20to%20help%20me%20with%20graphing%20my%20data.%20I%20appreciate%20the%20help%20and%20support.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-855920%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
laport14
New Contributor

Greetings,

 

I have a decent size set of data that I need to put into a Pareto chart. Ideally, I want to show the total delay time for the for the year based on the code in which the delay came from. Also if there is any possibility of me being able to filter the data going into the Pareto and add future data to the Pareto chart in an easy manner for updating purposes, I would be grateful to learn how. Also attached is a Pareto Template that I would like to base my filtering on (see the 2nd sheet "12 bar single graph #1" as an example). This template allows me to filter the graphed data based on date, source, and areas. In the attached document "Large Data Set" I have a Pareto sheet created for the data that I would like to graph. Please let me know if you may need any further information to be able to help me with graphing my data. I appreciate the help and support.  

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies