Prev: Export from Excel to Word
Next: How does Excel smooth chart data when smooth option is selected?
From: rahmad on 5 Apr 2007 04:38
Yes,
I found it,but how to create the pareto chart.
I didn't understan how to create it.

"rahmad" <chooriang(a)gmail.com> wrote in message
news:OBzQJ6ndHHA.4784(a)TK2MSFTNGP06.phx.gbl...
> 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" <mike(a)mikemiddleton.com> wrote in message
> news:ORx68gldHHA.1216(a)TK2MSFTNGP03.phx.gbl...
> > 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" <chooriang(a)gmail.com> wrote in message
> > news:OMygGAldHHA.208(a)TK2MSFTNGP05.phx.gbl...
> > > hi all,
> > > would somebody advise me how to make
> > > automatic pareto chart.
> > >
> > > thank's before
> > >
> > >
> >
> >
>
>


From: James Silverton on 5 Apr 2007 10:03
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

From: James Silverton on 5 Apr 2007 13:59
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

From: rahmad on 5 Apr 2007 21:57
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" <not.jim.silverton(a)comcast.not> wrote in message
news:#sK6rw6dHHA.4688(a)TK2MSFTNGP04.phx.gbl...
> 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
>


From: James Silverton on 5 Apr 2007 23:42
rahmad wrote on Fri, 6 Apr 2007 09:57:02 +0800:

r> "James Silverton" <not.jim.silverton(a)comcast.not> wrote in
r> message news:#sK6rw6dHHA.4688(a)TK2MSFTNGP04.phx.gbl...
??>> 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

First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: Export from Excel to Word
Next: How does Excel smooth chart data when smooth option is selected?