# 2.10.16 plot_paretobin

Plot: 2D: 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; 

## Variables

Display
Name
Variable
Name
I/O
and
Type
Default
Value
Description
Data Input Range datarng

Input

Range

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

Input

Range

<active>
Specify the input range of count.
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 binned data. Please refer to this 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

Keywords:cumulative total