The following whitepapers highlight
these application areas:
A. Macro Concepts
a. A SigmaPlot Macro Tutorial
i. Recording a Macro - A tutorial showing how to record a macro that fits a decaying exponential curve to two data sets.
ii. Creating a New Toolbox Ribbon Button and Adding a Macro Name To It - This allows you to run a macro from a ribbon button.
iii. Run a Macro from a Toolbox Ribbon Button - Click a button to run the macro.
iv. Adding a For-Loop to Your Macro - Allows fitting multiple data sets
a Dialog to a Macro - Describes how to create a dialog user interface to a macro.
Issues With Recorded Macros
1. Making the Graph Page the Currently Displayed Window - Bring the graph page to the front.
2. Using Statements from Recorded Macros - Record a macro to get macro code for other applications.
Processing using SigmaPlot Automation - Select
a group of Excel files to process in
a batch. This macro fits a user-selected
SigmaPlot curve fit equation to the
data, creates a graph and saves the
results for all Excel files in a SigmaPlot
c. SigmaPlot Macro Sample Code - Useful macro sample code is provided for the user to copy. [top]
Rowwise Statistics Transform -
This transform computes rowwise
statistics. It complements
the columnwise statistics available from the main
Functions Root and
These two new functions have
been added to solve
a. Histogram Plus Kernel Density - Histogram and cumulative histograms are created from a single column of data. Four graph types and other options are provided. The smooth kernel density estimate of the probability density is also provided.
Histogram - A three-dimensional bar-graph
histogram is created from bivariate data.
Error Bars - This
macro creates one of three
types of graphs with asymmetric
error bars from relative
error bar data.
Your Graphs for Journal or Web Publication - A
discussion of the graph file formats used and/or
required for journal and web publication.
Control Charts - Xbar and Range charts
are created using the SigmaPlot Reference Line
Graph - This transform uses XZ profiles
from XY Many Z data to generate the individual
ribbons of a ribbon graph. This transform is located
in your SigmaPlot Transforms folder.
Between Two Curves - This macro creates
a shade between two curves. It complements SigmaPlot’s
built-in area plot feature that shades area under
the curve to the X-axis. The macro assumes the
data for both curves is strictly increasing in
SigmaPlot graphs for Submission
to the FDA -
The procedure is described
for pasting SigmaPlot graphs
into Microsoft Word that fit within specified margins
and have a fixed font size. [top]
of Ligand Binding Data - Competition, saturation and dose-response studies may be analyzed with SigmaPlot. Multiple replicate data sets are fit using an equation selected from a list of ten — and you may add your own. Graphical results, EC50 values and a statistical report are produced.
Dissolution Test Data with
Excel Spreadsheet -
An Excel worksheet analyzes
up to 12 vessel by 6 sample
time dissolution test data.
Publication quality graphs
of the results are simultaneously
c. Shelf Life Time Analysis
Shelf Life Time with SigmaPlot - An
exact computation of shelf
life time is computed and
graph created. Four designs
are available – lower
only, lower and upper
of the Shelf Life Macro - Confirms
accuracy of the Shelf
iv. Transform [top]
Three real-world examples
with increasing variability
show the usefulness of
data smoothing algorithms
to visualize the information
in the data. [top]
e. Controlled Release Analysis
Controlled Release and Dissolution
Data - Five
controlled release models
for analysis of drug
dissolution data are
implemented as a SigmaPlot
fit library. One or all
models may be easily
fitted to your data.
Equations in the SigmaPlot
Fit Library [top]
Analysis of Concentration
Response Curves - Global
curve fitting without
Curve Fit of Enzyme Kinetics
Data - A
demonstration of simultaneous
fitting of multiple
functions to multiple
data sets with shared
Curve Fitting for Ka and
Kd from Sedimentation - A
global analysis of
i. Global Curve Fitting - Dose
j. Curve Fitting / Regression
Nonlinear Regression -
A four-segment piecewise
linear equation is
fit to rowwise replicate
Functions in Nonlinear
m. Parameter Confidence
Intervals in Reports
n. Implicit Function Curve Fitting
o. ROC Curves Analysis
Curves Analysis [top]
E. SigmaPlot & Excel
a SigmaPlot Graph in Excel - An
Excel macro that creates
a SigmaPlot graph in Excel.
b. Using Macros to Place SigmaPlot Charts Within Microsoft Aplications - The macro statements required to insert a SigmaPlot graph into a PowerPoint slide are shown and explained. The similar procedure for placing a graph in Word is then shown. [top]
F. SigmaPlot & MatLab
a. MATLAB® SigmaPlot™ Functions [top]
G. Data Formats
a. Replicate Data Format
b. X,Y Many Z to X, Y, Z Format -This transform converts from one format to another. For example, the 3D smoothing algorithms requires data in XYZ format. [top]