Difference between revisions of "Create a Pareto Chart in MS Excel 2010"
m (importing article from wikihow) |
m (Text replacement - "== Video ==" to "") |
||
(4 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
Pareto Analysis is a simple technique for prioritizing potential causes by identifying the problems. The article gives instructions on how to create a Pareto chart using MS Excel 2010. | Pareto Analysis is a simple technique for prioritizing potential causes by identifying the problems. The article gives instructions on how to create a Pareto chart using MS Excel 2010. | ||
− | [[Category:Microsoft Excel]] | + | [[Category: Microsoft Excel]] |
== Steps == | == Steps == | ||
#Identify and List Problems. Make a list of all of the data elements/work items that you need to prioritize using the Pareto principle. This should look something like this. | #Identify and List Problems. Make a list of all of the data elements/work items that you need to prioritize using the Pareto principle. This should look something like this. | ||
Line 28: | Line 28: | ||
#*However, you can still go ahead and Add some final touch to your Pareto to make it more appealing.<br>Go to Chart Tools --> Layout. You can add Chart Title,Axis Title,Legend and Data Tables, if you want. | #*However, you can still go ahead and Add some final touch to your Pareto to make it more appealing.<br>Go to Chart Tools --> Layout. You can add Chart Title,Axis Title,Legend and Data Tables, if you want. | ||
− | + | ||
− | + | ||
== Warnings == | == Warnings == |