2.10.17 plot_paretoraw

Menu Information

Plot: 2D: Pareto: Pareto Chart - Raw Data

Brief Information

Create Pareto plot from raw data

Command Line Usage

1. plot_paretoraw -r 2 irng:=[Book1B]Sheet1!C"Food Defect";

2. plot_paretoraw irng:=1!2 combine:=1 mode:=count threshold:=5 label:="Others";

X-Function Execution Options

Please refer to the page for additional option switches when accessing the x-function from script

Variables

Display
Name 		Variable
Name 		I/O
and
Type 		Default
Value 		Description
Input irng

Input

Range

<active>
 Specify the input range of data.
Show Cumulative Percent Plot cum

Input

int

1
 Specify whether to show the cumulative percent plot on the Pareto chart. 0 = uncheck this checkbox to hide the cumulative percent plot. 1 = check this box to show the cumulative percent plot.
Combine Smaller Values combine

Input

int

0
 Specify whether to combine the data of which the counts are below a threshold. 0 = uncheck this checkbox to disable the combination. 1 = check this box to combine the data.
Threshold mode

Input

int

percent
 Specify the method to define the threshold. Option list:
  • percent(0):By Percent
Use percent value to define the threshold.
  • count(1):By Count
Use count value to define the threshold.
  • bar(2):By Bar Number
Use bar number to define the threshold.
Threshold value threshold

Input

double

Specify the value of the specified threshold.


By Percent: Accessible only when By Percent is chosen in Threshold. The data of which the count's percentage is smaller than this value will be combined as one category in the plot.

By Count: Accessible only when By Count is chosen in Threshold. The data of which the count number is smaller than this value will be combined as one category in the plot.

By Bar Number: Accessible only when By Bar Number is chosen in Threshold. The created Pareto chart will have n bars specified in this edit box. The data of which the bin order is greater than n-1 will be combined as one category in the plot.

Tick Label label

Input

string

Other
 Specify the tick label for the combined smaller values.
Output Data rd

Output

ReportData

[<input>]<new>
 Specify where to store the calculated data for the plot.

Description

This X-Function is used to plot the Pareto chart from raw data. Please refer to this page to see how to creat a Pareto chart.

Note: in Origin 2017 or ealier versions, this X-Function It is not accessible from LabTalk script. To plot Pareto chart from script, you will need to use 

worksheet -px

For example, the following script plot column C in sheet1, book1 into a 5-bar Pareto plot. 

worksheet -px ? ParetoRaw plot_paretoraw datarng:=1!A"Data" countrng:=1!B"Count" combine:=1 mode:=count threshold:=5;

Related X-Functions

plot_paretobin

Keywords:cumulative total
English | Deutsch | 日本語