2.10.20 plot_paretobin

Contents

Menu Information

Plot > Statistical: Pareto: Pareto Chart - Binned Data

Brief Information

Create Pareto plot from binned data

Command Line Usage

1. plot_paretobin -r 1 datarng:=1!A"Data" countrng:=1!B"Count";

2. plot_paretobin datarng:=1!A countrng:=1!B combine:=1 threshold:=10;

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
Data datarng

Input

Range

<active>
 Specify the input range of data.
Count countrng

Input

Range

<active>
 Specify the input range of count.
Group group

Input

Range

<optional>
 Specify the grouping column.
Multiple Groups mulgroups

Input

int

0
 Specify how to arrange the plots divided by groups.

Option list:

  • Separate Panels in Same Graph: The pareto charts will be plotted into separate panels on same graph by groups.
  • Separate Graphs: The pareto charts will be plotted as separate graphs by groups.
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.
Show Symbol at Right Side of Bar symr

Input

int

1
 Specify whether show the scatter symbol at the right side of bar instead of center of bar. 1 = check this box to show symbol at right side of the bar.
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.
Output Graphs rt

Output

ReportTree

[<same>]<new>
 Specify where to store the result graphs.

Description

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

Note: in Origin 2017 or ealier versions, this X-Function cannot be accessed by 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 Pareto plot, with Recalculate Mode = Auto. 

worksheet -px ? ParetoBin plot_paretobin datarng:=1!1 countrng:=1!2 -r 2;

Related X-Functions

plot_paretoraw

Keywords:cumulative total