Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating a pareto chart
hi all,
would somebody advise me how to make automatic pareto chart. thank's before |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating a pareto chart
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating a pareto chart
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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating a pareto chart
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 |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating a pareto chart
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 |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating a pareto chart
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 |
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating a pareto chart
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 |
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating a pareto chart
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 |
#9
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating a pareto chart
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 |
#10
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating a pareto chart
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 |
#11
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating a pareto chart
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 |
#12
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating a pareto chart
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 |
#13
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating a pareto chart
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 |
#14
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating a pareto chart
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Anorexic columns on my pareto chart | Excel Discussion (Misc queries) | |||
Pareto Chart | Charts and Charting in Excel | |||
how do you create a Pareto Chart | Charts and Charting in Excel | |||
Auto Pareto Chart | Charts and Charting in Excel | |||
How do I set up a Pareto chart in Excel? | Charts and Charting in Excel |