Create Pareto Chart in Excel?

T

Tycon22

I was wondering if it was possible to create a pareto chart in excel? I
so, does anyone have a tutorial on how to do so? Thanks
 
B

Barb Reinhardt

You'll need the Analysis Toolpack to create Pareto Charts. Once installed,
run Data Analysis and choose Histogram. An option for the Histogram tool
is Pareto.
 
M

Michael R Middleton

Tycon22 -
I was wondering if it was possible to create a pareto chart in excel? If
so, does anyone have a tutorial on how to do so? Thanks. <
Click to expand...

What is the format of the data? That is, is it a list of text values, or is
it already summarized in a sorted frequency distribution?

The Histogram tool has a Pareto option, but it's limited to summarizing
numerical values.

- Mike

www.mikemiddleton.com
 
B

Barb Reinhardt

If it's a list of text values, I've always used Pivot Tables to get the data
for the Pareto.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a chart from a table in word thats dynamic 0
how can i make pareto chart on 2 axis in excel? 1
How to display the merge function "url" of a picture? 0
Filtered view of Visio Chart 0
Export BPMN Visio Chart to Excel 0
Doughnut Chart linked with the slicer in the pivot table 0
Trendline partial data start point 1
how to get a pareto diagram in excel 1

Top