Prev: Export from Excel to Word
Next: How does Excel smooth chart data when smooth option is selected?
From: rahmad on 3 Apr 2007 20:35
hi all,
would somebody advise me how to make
automatic pareto chart.

thank's before


From: Barb Reinhardt on 3 Apr 2007 20:50
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
>
>
>
From: Mike Middleton on 3 Apr 2007 21:26
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: rahmad on 4 Apr 2007 02:07
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: rahmad on 4 Apr 2007 08:36
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" <BarbReinhardt(a)discussions.microsoft.com> wrote in message
news:727011F7-E985-4E49-AC30-47CC9C7B4026(a)microsoft.com...
> 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
> >
> >
> >


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