R
rahmad
hi all,
would somebody advise me how to make
automatic pareto chart.
thank's before
would somebody advise me how to make
automatic pareto chart.
thank's before
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Barb Reinhardt
Ensure that the Analysis Tool Pack add-in is enabled.
Tools -> Data Analysis -> Histogram
should get you where you need to be.
Tools -> Data Analysis -> Histogram
should get you where you need to be.
M
Mike Middleton
rahmad -
The answer depends on what your data look like, and it's unlikely that there
is an "automatic" method.
The Analysis ToolPak has a Histogram tool with a Pareto option, but it's
limited to summarizing numeric data.
So, if you have text data, you may need to develop counts using a pivot
table or COUNTIF worksheet functions, and then use the Chart Wizard to
create a Column or Bar chart.
- Mike
http://www.mikemiddleton.com
The answer depends on what your data look like, and it's unlikely that there
is an "automatic" method.
The Analysis ToolPak has a Histogram tool with a Pareto option, but it's
limited to summarizing numeric data.
So, if you have text data, you may need to develop counts using a pivot
table or COUNTIF worksheet functions, and then use the Chart Wizard to
create a Column or Bar chart.
- Mike
http://www.mikemiddleton.com
R
rahmad
I have data in my pivot table And I'm just getting dizzy how to
create an automatic pareto chart every time I turn the pages.
All the data in my pivot table are numeric data and summarize
by sum but it seems will be OK if I know too what if my data
are some texts.
Hope somebody will guide me to the right direction.
I use Windows 200
and excel version 9.0
create an automatic pareto chart every time I turn the pages.
All the data in my pivot table are numeric data and summarize
by sum but it seems will be OK if I know too what if my data
are some texts.
Hope somebody will guide me to the right direction.
I use Windows 200
and excel version 9.0
R
rahmad
And I didn't see any option named Data Analysis
or found something refer to Analysis Tool Pack.
Do I have a problem with my excel application?
or found something refer to Analysis Tool Pack.
Do I have a problem with my excel application?
A
Andy Pope
Hi,
To enable analysis pak use
Tools > Add-Ins... tick the Analysis ToolPak
You should then see the menu item Barb mentions.
Cheers
Andy
To enable analysis pak use
Tools > Add-Ins... tick the Analysis ToolPak
You should then see the menu item Barb mentions.
Cheers
Andy
R
rahmad
Yes,
I found it,but how to create the pareto chart.
I didn't understan how to create it.
I found it,but how to create the pareto chart.
I didn't understan how to create it.
J
James Silverton
rahmad wrote on Thu, 5 Apr 2007 16:38:51 +0800:
r> "Yes,
I found it,but how to create the pareto chart.
I didn't understan how to create it.
r>
You need a column of values and a column of bin limits into
which the occurences are counted. Why not try it for yourself
with a small set of data?
James Silverton
Potomac, Maryland
E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not
r> "Yes,
I found it,but how to create the pareto chart.
I didn't understan how to create it.
r>
You need a column of values and a column of bin limits into
which the occurences are counted. Why not try it for yourself
with a small set of data?
James Silverton
Potomac, Maryland
E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not
J
James Silverton
James wrote to rahmad on Thu, 5 Apr 2007 10:03:20 -0400:
r>> "Yes,
JS> I found it,but how to create the pareto chart.
JS> I didn't understan how to create it.
r>>
JS> You need a column of values and a column of bin limits
JS> into which the occurences are counted. Why not try it for
JS> yourself with a small set of data?
Perhaps I was a bit abrupt here but often the best way to find
out how things work is to try a simple case. Anyway, the route
in Office 2002 is Tools>Data Analysis> Histogram.
Range =location of data, bins, results. There will be choices
for Pareto and plotting.
James Silverton
Potomac, Maryland
E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not
r>> "Yes,
JS> I found it,but how to create the pareto chart.
JS> I didn't understan how to create it.
r>>
JS> You need a column of values and a column of bin limits
JS> into which the occurences are counted. Why not try it for
JS> yourself with a small set of data?
Perhaps I was a bit abrupt here but often the best way to find
out how things work is to try a simple case. Anyway, the route
in Office 2002 is Tools>Data Analysis> Histogram.
Range =location of data, bins, results. There will be choices
for Pareto and plotting.
James Silverton
Potomac, Maryland
E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not
R
rahmad
I tried it James,
But The results doesn't look like what I want.
I don't understand why this chart have 4 series only.
I want to tell you
currently I have 11 series point
,I just want my charts series arrangging descendly.
Of course automatically.If possible?
But The results doesn't look like what I want.
I don't understand why this chart have 4 series only.
I want to tell you
currently I have 11 series point
,I just want my charts series arrangging descendly.
Of course automatically.If possible?
J
James Silverton
rahmad wrote on Fri, 6 Apr 2007 09:57:02 +0800:
r> message ??>> James wrote to rahmad on Thu, 5 Apr 2007 10:03:20 -0400:
??>>
r>>>> "Yes,
JS>>> I found it,but how to create the pareto chart.
JS>>> I didn't understan how to create it.
r>>>>
JS>>> You need a column of values and a column of bin limits
JS>>> into which the occurences are counted. Why not try it for
JS>>> yourself with a small set of data?
??>>
??>> Perhaps I was a bit abrupt here but often the best way to
??>> find out how things work is to try a simple case. Anyway,
??>> the route in Office 2002 is Tools>Data Analysis>
??>> Histogram. Range =location of data, bins, results. There
??>> will be choices for Pareto and plotting.
??>>
Just to be sure, why don't you try a single column of points and
a column of bins? Just fill in randomly about 30 points with
values from 0 to 100, say, and have bins at 30, 60, 90, say. See
if that works and then I'll try to help with your data. At the
moment, I'm not really sure what you are trying to do.
James Silverton
Potomac, Maryland
E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not
r> message ??>> James wrote to rahmad on Thu, 5 Apr 2007 10:03:20 -0400:
??>>
r>>>> "Yes,
JS>>> I found it,but how to create the pareto chart.
JS>>> I didn't understan how to create it.
r>>>>
JS>>> You need a column of values and a column of bin limits
JS>>> into which the occurences are counted. Why not try it for
JS>>> yourself with a small set of data?
??>>
??>> Perhaps I was a bit abrupt here but often the best way to
??>> find out how things work is to try a simple case. Anyway,
??>> the route in Office 2002 is Tools>Data Analysis>
??>> Histogram. Range =location of data, bins, results. There
??>> will be choices for Pareto and plotting.
??>>
Just to be sure, why don't you try a single column of points and
a column of bins? Just fill in randomly about 30 points with
values from 0 to 100, say, and have bins at 30, 60, 90, say. See
if that works and then I'll try to help with your data. At the
moment, I'm not really sure what you are trying to do.
James Silverton
Potomac, Maryland
E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not
R
rahmad
I'm sorry james,
I just want my charts appear looks like a pareto charts.
The highest series is on the left,beside it is the second
highest,beside it again is the third highest and so on.
I just want my charts appear looks like a pareto charts.
The highest series is on the left,beside it is the second
highest,beside it again is the third highest and so on.
J
Jon Peltier
We already know what a Pareto chart is. James is telling you how to bin your
data, but I suspect you already have your data in columns of category and
count. Sort your data in decreasing order by count and make a column chart
with the two columns of data. There's your pareto chart.
- Jon
data, but I suspect you already have your data in columns of category and
count. Sort your data in decreasing order by count and make a column chart
with the two columns of data. There's your pareto chart.
- Jon
R
rahmad
You 're right Jon,
I ever made it,but I was not satisfied
with the result.I didn't know how to format
axis right under its correct series point
I ever made it,but I was not satisfied
with the result.I didn't know how to format
axis right under its correct series point
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.