hi all,
would somebody advise me how to make
automatic pareto chart.

thank's before

Ensure that the Analysis Tool Pack add-in is enabled.
Tools - Data Analysis - Histogram
should get you where you need to be.
"rahmad" wrote:

hi all,
would somebody advise me how to make
automatic pareto chart.

thank's before

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

"rahmad" wrote in message
...
hi all,
would somebody advise me how to make
automatic pareto chart.

thank's before

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
"Mike Middleton" wrote in message
...
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

"rahmad" wrote in message
...
hi all,
would somebody advise me how to make
automatic pareto chart.

thank's before

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?

"Barb Reinhardt" wrote in message
...
Ensure that the Analysis Tool Pack add-in is enabled.
Tools - Data Analysis - Histogram
should get you where you need to be.
"rahmad" wrote:

hi all,
would somebody advise me how to make
automatic pareto chart.

thank's before

Hi,

To enable analysis pak use
Tools Add-Ins... tick the Analysis ToolPak

You should then see the menu item Barb mentions.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"rahmad" wrote in message
...
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?

"Barb Reinhardt" wrote in
message
...
Ensure that the Analysis Tool Pack add-in is enabled.
Tools - Data Analysis - Histogram
should get you where you need to be.
"rahmad" wrote:

hi all,
would somebody advise me how to make
automatic pareto chart.

thank's before

Yes,
I found it,but how to create the pareto chart.
I didn't understan how to create it.

"rahmad" wrote in message
...
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
"Mike Middleton" wrote in message
...
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

"rahmad" wrote in message
...
hi all,
would somebody advise me how to make
automatic pareto chart.

thank's before

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

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 ToolsData 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

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?

"James Silverton" wrote in 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 ToolsData 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

rahmad wrote on Fri, 6 Apr 2007 09:57:02 +0800:

r "James Silverton" wrote in
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 ToolsData 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

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.



"James Silverton" wrote in message
...
rahmad wrote on Fri, 6 Apr 2007 09:57:02 +0800:

r "James Silverton" wrote in
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 ToolsData 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

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"rahmad" wrote in message
...
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.



"James Silverton" wrote in message
...
rahmad wrote on Fri, 6 Apr 2007 09:57:02 +0800:

r "James Silverton" wrote in
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 ToolsData 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

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

"Jon Peltier" wrote in message
...
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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"rahmad" wrote in message
...
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.



"James Silverton" wrote in message
...
rahmad wrote on Fri, 6 Apr 2007 09:57:02 +0800:

r "James Silverton" wrote in
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 ToolsData 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