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

Copper 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.  

0 Replies