Prev: Export from Excel to Word
Next: How does Excel smooth chart data when smooth option is selected?
From: rahmad on 6 Apr 2007 04:08
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" <not.jim.silverton(a)comcast.not> wrote in message
news:ehGrJ2$dHHA.4340(a)TK2MSFTNGP06.phx.gbl...
> 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
>


From: Jon Peltier on 6 Apr 2007 08:05
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" <chooriang(a)gmail.com> wrote in message
news:O%23sEMHCeHHA.1388(a)TK2MSFTNGP05.phx.gbl...
> 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" <not.jim.silverton(a)comcast.not> wrote in message
> news:ehGrJ2$dHHA.4340(a)TK2MSFTNGP06.phx.gbl...
>> 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
>>
>
>


From: rahmad on 9 Apr 2007 08:17
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" <jonxlmvpNO(a)SPAMpeltiertech.com> wrote in message
news:OcBLAQEeHHA.2332(a)TK2MSFTNGP04.phx.gbl...
> 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" <chooriang(a)gmail.com> wrote in message
> news:O%23sEMHCeHHA.1388(a)TK2MSFTNGP05.phx.gbl...
> > 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" <not.jim.silverton(a)comcast.not> wrote in message
> > news:ehGrJ2$dHHA.4340(a)TK2MSFTNGP06.phx.gbl...
> >> 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  | 
Pages: 1 2 3
Prev: Export from Excel to Word
Next: How does Excel smooth chart data when smooth option is selected?