T O P I C R E V I E W |
x703jko |
Posted - 06/14/2005 : 4:25:55 PM Origin Version (Select Help-->About Origin): 7.5 SR5 Operating System: XP
Is there an easy way to make a Pareto Chart using Origin?
Please help.
Thanks Jeff |
7 L A T E S T R E P L I E S (Newest First) |
Hideo Fujii |
Posted - 06/14/2005 : 6:35:48 PM Hi Jeff,
As Mike mentioned, Origin currently does NOT have the graph type for the Parato Chart to make it in one-touch. However, as Parato Chart is a simply a cumulative plot of percentage, it is relatively easy to achieve it step-by-step like by the following example:
========================================== 1) Original Data A(X): a, b, c, d B(Y): 2, 3, 1, 4
2) Sort Descending: A(X): d, b, a, c B(Y): 4, 3, 2, 1
3) Calculate %: A(X): d, b, a, c B(Y): 4, 3, 2, 1 C(Y): 40, 30, 20, 10
4) Cumulate: A(X): d, b, a, c B(Y): 4, 3, 2, 1 C(Y): 40, 30, 20, 10 D(Y): 40, 70. 90, 100
This can be done by a simple script such as: Data1_D[1]=Data1_C[1]; for(ii=2; ii<=wks.maxrows; ii++) Data1_D[ii]=Data1_C[ii]+Data1_D[ii-1];
5) Hilight C(Y) and D(Y) columns, and make a Column Graph of these datasets
6) Double-click the graph, and select the "Independent" in Edit Mode from the Group tab.
7) From Data menu, select Data1:A(X),D(Y) to activate
8) Click Line+Symbol graph type tool button
9) In Axis dialog for X axis, select "Custom Tick Labels", and set the holizontal "Offset in % with Axis" to, e.g., -100 .
10) Do any other customization.
You can get like:
==========================================
You can automate these steps by using LabTalk or by OriginC.
Hope this help you a little.
OriginLab Hideo Fujii
|
Mike |
Posted - 06/14/2005 : 5:19:16 PM Hi Jeff,
I looked into whether this would be implemented for Origin 8 but, unfortunately, it doesn't look like it will make it in. I'm sure you are correct about its usefulness. Most of these items make it into the features database because someone has requested it.
So, you may want to check back with us after Origin 8 is released. Sorry we couldn't be of more help to you.
Mike OriginLab |
x703jko |
Posted - 06/14/2005 : 5:11:29 PM Thanks. I will await 8.0
I am sure that I'm not the only user that will benefit from having a pareto chart feature in Origin.
Thanks again for your help.
Jeff |
Mike |
Posted - 06/14/2005 : 4:56:07 PM Okay; hoped it might work for you.
I did find a request for Pareto Charts in our "requested features" database, so I have added your forum post to it. It is marked "Origin 8" but I'll have to check to see whether they still plan to add this feature for the next release, or not.
If you want to check back to see whether this has been added, you can refer to "QA 5862" (the database item number).
Sorry we didn't have what you were looking for.
Mike OriginLab
Edited by - Mike on 06/14/2005 4:57:13 PM |
x703jko |
Posted - 06/14/2005 : 4:45:14 PM Nope..QC won't do it.
Jeff |
x703jko |
Posted - 06/14/2005 : 4:39:31 PM Thanks. I'll check it out. Jeff |
Mike |
Posted - 06/14/2005 : 4:38:05 PM Hi Jeff,
Origin creates a QC Chart; I don't know if this will give you what you need or not. For information on this chart type, see the Origin Help file topic The Graph: Types > Statistical Graphs > Creating QC Charts. There is also a sample project -- QC CHART.OPJ -- located in your Origin \SAMPLES\GRAPHING\STATISTICAL GRAPHS folder.
Mike OriginLab |
|
|