Batch Plotting (ORG-3002)
Duplicate with New Sheets/Books (ORG-8946)
User often creates a graph with data from same sheet or same book, then wants to repeat that same graph using a different sheet or book that has the exact same structure.
After plotting such a graph, right click Graph window title and choose Duplicate (Batch Plotting): Duplicate with New Sheets/Books... . A dialog will open with all matching sheets or books as used in the graph. User can pick sheets/books to duplicate the graph.
Duplicate with New Columns – not done yet (ORG-8863)
User plots one data plot and then wants to repeat the same plot using other columns.
Change Worksheet of data plot (ORG-7993)
User plots a data plot from one worksheet, but then wants to replace the plot with the same column of data from another worksheet. The two worksheets have the same structure. Select the plot, then right-click and choose Change Worksheet.
Grouped Plot (ORG-946)
Grouped Box Chart (Indexed ORG-948, Raw ORG-8510)
Menus and buttons are added under Plot: Statistics menu.
Put Sample opj here
Grouped Column Graph (ORG-5344)
Menus and buttons are added under Plot: Column/Bar/Pie menu.
Grouped Stacked Column Graph (ORG-949)
User can set subgroup size of a stacked column in Plot Details dialog. E.g the following data.
After plotting Stacked Column graph, if user wants to plot all BMW together and Ferrari together, open Plot Details, Set Subgroup Size on Group tab.
Check Use Subgrouping (in Group tab) for Cumulative checkbox on Stack tab
Improvements to Existing Graph Types
New Polar Graph (ORG-7889)
- New axis dialog with more control of Radial and Azimuth axes (ORG-5420, ORG-8184)
- Different unit support for Azimuth axis ( ORG-2267, ORG-8137)
- Flexible Start Angle&Orientation Combination (ORG-1796)
- Crop (ORG-5420). To access Crop controls, right-click on the plot and Axis..., then select Miscellaneous in the Axis Dialog box.
- New control features in Azimuth grid lines (ORG-1796)
New Box Chart (ORG-2523)
Box width and position with information from Column Label Rows (ORG-1943, ORG-4094)
User can put Box width and Box position information in Column Label Rows.
Then on Box tab in Plot Details dialog, use the Box Width(%) dropdown list and Scaling Factor for Box width control.
Use X Position dropdown list for Box position control.
More control of data +box
Data can show above box (ORG-5901)
Data display width. Setting Data Width to 0 will show data in a line. (ORG-5881)
Data point symbol color by indexing (ORG-1905)
I Shape Box (ORG-7839)
Controls are on the Box tab of Plot Details. Set Style to I-Shaped Box.
Individual line control of different lines (whisker, cap, median, mean, distribution curve) (ORG-816)
Box Chart Legend (ORG-4346)
Right click graph and choose Add/Update Legend Entries:Box Chart Components.
Built-in Box Chart Themes (ORG-7916)
With Box chart graph window active, open Tools:Theme Organizer.
We provide some common box chart themes. User can apply it to quickly change box chart.
Fill Area between two Line Plots (ORG-3693)
After plotting a graph with two line plots. User can Fill to next data plot - One Color, Fit to next data plot - Above Below Colors to fill color(s) between two line plots.
Column/Bar with Variable Width (ORG-4155)
On Spacing tab of Plot Details dialog, user can set which column to be used as column width. Also support Scaling Factor.
Akima and Modified Bezier Line Connect (ORG-3238)
Ternary Contour from Matrix with r and therta as X and Y
New Plot Types
Piper/Trilinear Diagram (ORG-5409)
Data must be organized in Ca, Mg, Na+K, Cl, SO4, CO3+HCO3 and in XYZXYZ column designation. TDS column is optional.
Highlight XYZXYZ columns and choose Plot: Specialized: Piper 
Customize the symbol shape to distinguish each sample.
Customize symbol size to show TDS
Marginal Histogram/Box Chart (ORG-8520)
Menus and Buttons are added under Plot: Statistics: menu.
Stacked Column/bar with Percentage(ORG-8825) - not done yet
3D OpenGL Waterfall (ORG-7998)
Menus and Buttons are added under Plot: 3D XYY: menu.
3D Ternary Surface (ORG-917)
Plot:3D Surface:3D Ternary Colormap Surface. Toolbar button is under Plot: 3D Colormap Surface group on 3D and Contour Graphs toolbar.
3D Triangle Patch by Specified Data Index (ORG-8141)
3D OpenGL Improvements
Data Labeling for XYZ and XYY Bars (ORG-5697)
Label tab in Plot Details dialog.
More 2D Symbol Shapes for 3D Scatter Graph (ORG-7769)
Open Plot Details for your 3D Scatter graph. On the Symbol tab, set Symbol Type to 2D, then select from 2D symbol shapes as in a 2D graph.
Link Contour Line Color to Colormap (ORG-4967)
Check Link Line to Colormap Color checkbox in Contour Lines dialog. Contour line color will follow colormap.
In the graph below, Fill color and Mesh lines are disabled.
Edit Range in 3D Graph (ORG-7973)
Only supports editing row and column indices.
Axis Break in 3D (ORG-6073)
Support in all 3 dimensions.
Support 3D Graph with Filtered Column (ORG-8302) - bug fix
In 9.0, for XYZ data, even if there is data filtering in a column, 3D graph will still plot all data. This is fixed in 9.1.
Plotting Improvements
Plot: User Defined: menu (ORG-8840)
In the past, if user customized a graph and saved it as a graph template, he/she has to go to Template Library to plot from customized template.
In 9.1, user can choose Plot: User Defined to see all customized graph templates and plot from it. It doesn't matter which category the graph template is saved into.
Graphing Improvements
2D Anti-aliasing (ORG-4987)
Added Anti-aliasing control so lines look better on monitor.
Smart Labeling for 2D plot Labels - not fully working yet (ORG-7923)
Line annotation with * in Column/Bar plots (ORG-8703) – todo
Isometric Support to Layer (ORG-2681)
For 2D Graphs, it's on Size/Speed tab of Layer level of Plot Details dialog. When this option is selected, X and Y axes will be forced to have the same length in pixel for the same scale increment. The check box will be hidden when the scale is not linear.
For 3D graphs, it's on Axis tab of Layer level in Plot Details dialog.
Legend Improvements (ORG-1925)
Easy way to add categorical Legend/box chart legend, etc.
If there is categorical data in a plot, or if the plot is box chart, when right-clicking the legend, there will bean Add/Update Legend Entries context menu item to easily add a corresponding legend.
Easier way to Update Legend (ORG-7650)
Right click the graph legend and choose Update Legend... from the context menu. This opens the legendupdate dialog box. When you set Auto Legend Translation Mode to Custom, a Legend Custom Format option is added, allowing you to choose meta-data options for customizing the legend. Note that this box allows text entry and custom entries are saved when the dialog is closed.
Customized Color/Shape/Interior Increment List for plot (ORG-2518, ORG-8795)
User can create and use his/her color list, shape list, or interior list when plotting graph.
In Plot Details dialog, set the Color, Shape or Interior to be Increment or Indexing
Then the Color List, Shape List and Interior List tabs will show. User can check Use custom increment list check box and then customize the increment list.
User can also right click in the gray area of the increment list and load an increment list or save the Increment list for future usage.
E.g. the following scatter plot uses customized color, shape and increment list. This is supported in other plot types.
Moving Parent Layer when Moving Linked Child Layer (ORG-8809)
Select the When dragged to reposition, also reposition parent layer check box on Size/Speed tab of a linked layer (layer level in the Plot Details dialog box). When moving a child layer, parent layer will follow.
3 Panning Modes – added Panning to Major/Minor Ticks (ORG-8511)
Support 3 panning mode.
- Pan by percent: Default behavior. Every time +/-/Left/Right key is pressed using mouse wheel to scroll once will pan by percent.
- Pan by major ticks: Every time +/-/Left/Right key is pressed using mouse wheel to scroll once will pan to next/previous major ticks.
- Pan by minor ticks: Every time +/-/Left/Right key is pressed using mouse wheel to scroll once will pan to next/previous minor ticks.
After user clicks 
button to go into Zoom and Panning mode, or holds down X key to go into Panning mode, user can press SPACE keyboard to toggle panning modes.
Add Multiple Graphs to Layout Together (ORG-8077)
Graph: Add Graphs to Layout... menu.
Better naming in Plot Details db (ORG-8935)
Tooltip when mousing over data plots on left panel.
Showing both Short Name and Long name in settings that can refer to a column.
Graph: Zoom All to show out of page objects (ORG-8234)
View:Zoom All menu to zoom out to see objects out of page. This is useful when there are unwanted objects in hidden area of graph window and causing trouble when exporting graph, etc.
Merge Graph Improvements (ORG-2404)
Add Label to each layer (ORG-8054)
User can choose to add alpha characters or custom labels to each layer when merging graphs.
Treat Layers in Each Source Graph as a Group (ORG-5394)
When merging graphs, all layers in source graph will be treated as a group, no matter linked or not linked.
Tree-like Axis Dialog (ORG-3964)
Multi-Axis Break ( ORG-298, ORG-7708)
Multi-Special Tick Labels (ORG-7883, ORG-1677)
User-defined Scale Formula (ORG-3964)
Multi-level Tick Labels (ORG-8556)
Apply settings to Others (ORG-7905)
Select Others to easily set settings in multiple corresponding nodes (ORG-5991)
Text XY in Virtual Matrix (ORG-8178)
Worksheet (ORG-6133)
Sparkline Improvements (ORG-7319)
Histogram and Box chart as Sparkline (ORG-8263)
Log10 X and Y support (ORG-7319)
Choose Column:Add or Update Sparklines...
Add Graph as Sheet (ORG-8797)
Right click sheet tab and choose Add Graph as Sheet... from the context menu. Creates a new sheet and adds one graph to a single worksheet cell.
Double click on the embedded graph to open an editable graph window. Note that th editable graph window has an arrow-like button in the upper right corner (in place of the usual Windows "delete" button). To exit the editable window and preserve customizations, click this arrow button. This closes the editable window and pushes updates back to the embedded graph.
Right click and choose Restore Window to delete the embedded graph and break the link to the original graph window.
Generate Patterned Data (ORG-7792)
Fill Column with patterened/random numbers, patterened/random date/time values, patterened or random set of strings.
Set Column Value Improvements (ORG-9021)
Formula column label row (ORG-6669)
User can right click workbook title and choose View: Formula to turn the formula on.Then type formula directly using the same syntax as used in Set Column Values dialog. E.g. col(B)-col(A), sin(col(A)), i*2, etc.
User can also open Set Column Values as before to set formula. The formula label row will update.
User can also uncheck Options: Direct Edit Formula Cell, and then choose Options: Formula Text... to type in some explanation of the formula, in cases like formula is complicated, etc.
Support subrange notation in Formula (ORG-9044)
E.g. enter StdDev(col(A)\[i-5:i+5]) in Formula to do running statistics
More built-in Functions added – todo (ORG-8781 ORG-7697 ORG-8945)
Different moving average functions are added under F(X): Statistics: menu.
E. g. Exponential Moving Average, Modified Moving Average, Triangular Moving Average, Weighted Moving Average
Keep Text option (ORG-8555)
In the past, if there are text in some data rows of a column, Set column value will change them into missing values.
Set Multiple Column Values (ORG-8554)
Select Multiple contiguous columns and choose Set Multiple Column Values context menu.
Use wcol(j) or cell(i,j) to refer to selected columns, e.g.
Example 1: Set Column B, C and D to be log10 of their original values.
Example 2: Set Whole Sheet2 to be all Values in Sheet1 times 10.
Reduce Columns (ORG-8538)
Choose Worksheet: Reduce Columns... menu.
We also added reduce by merged values option in Reduce Rows dialog.
Sort Column by Values in Column Label Rows - (ORG-8340)
You can sort worksheet columns by information in column label rows. From the main menu, choose Worksheet: Sort Columns by Label...
Column Filter Improvements (ORG-6064)
Copy Column To and Save Filter Info. in Operation (ORG-6078)
Sometimes user may want to change filter conditions and want to plot the graphs for each filter conditions. User can use Copy Columns To context menu to copy the columns to elsewhere and save the filter condition within the copied data. Then plot graph from it.
Then if user changes original worksheet's filter conditions, it will not affect the copied data and its graph.
Row index i support in condition (ORG-7975)
Stack/Unstack/Pivot Table Improvements (ORG-3656)
More Copy Column options (ORG-7937)
Select a column and right-click >
- Copy (Formula): Copy Set Column Value settings
- Copy (Label Rows): Copy Column Rows
- Copy (Formula and Label Rows): Copy both Set Column Value Settings and Label Rows
Analysis
Copy/Paste Operation(ORG-7944)
This is not supported for all analyses, but it can be very useful to copy operation and then paste to all curves in another graph, etc.
Fitting Improvements
LR/PR: Support showing parameter values in equation (ORG-5119)
Custom X Column Data for fitted curve (ORG-7459)
Fitting Function Builder: Easy way to edit parameters (ORG-8380)
Surface Fit: Add fitted surface to source graph (ORG-8434)
Partial Least Squares Regression (ORG-5412)
Global Fit Speed Improvements (ORG-8883)
Compare Models/Dataset Improvements (ORG-8445)
BIC in Compare Model (ORG-6495)
Friendly naming of models (ORG-8460)
Fit and Rank all functions in a category (ORG-8257)
Set Numeric Settings for Report (ORG-8413)
Global setting of Digits in Report on Numeric Format tab of Tools:Options dialog box.
Adjust Footnote Size (ORG-8515)
If user feels Footnote size is too small in report sheet, there is global Footnote Size Ratio on Miscellaneous tab of Tools:Options dialog.
User may need to Refresh result sheet to see the change.
Akima Spline Interpolation (ORG-3238)
Input/Output Data tooltip (ORG-7799)
Easier for user to read Input Data info. without expanding Input Data node.
Useful to see where data will be output too as well.
Gadget (ORG-6642)
New Output to All Curves/All Layers (ORG-8188)
After determining region of interest and customizing settings, choose New Output for All Curves or New Output for All Layers to do the analysis on all curves and output the result.
Hotkey O for New Output action (ORG-8185)
Pressing O with a gadget active is equal to clicking the gadget's menu button (the small arrow in the upper right corner of the gadget) and choosing New Output.
Indicate Scatter Points in ROI in Cluster Gadget (ORG-8432)
Smart Labeling of Peaks in Quick Peak Gadget (ORG-8681)
Output gadget results to a tree variable (ORG-8124)
Importing (ORG-6948)
Import Mat File Structure (ORG-8462)
Choose File: Import: MatFile(MAT)... to import all variables in MAT file into a worksheet.
Click each variable in the worksheet to import the variable into a new worksheet of the same workbook.
Excel Import Improvements
More options in File: Import Excel dialog (ORG-8827)
Replace Existing Data option is added in 1st File Import Mode
Exclude Empty Sheets checkbox is added.
Reimport of Excel File (ORG-8826)
If user has modified the excel file in Origin, can use File: Reimport Directly to reimport the xls file.
Or if outside xls file has been changed, user can choose File: Reimport Directly to reimport the xls.
ASCII Import Improvements
Save import settings to <sheet> automatically (ORG-7725)
This way, if user saves template(OTW), or analysis template (OGW, OPJ), the import setting is saved as well.
Transpose in Import (ORG-8551)
Skip Columns in Import ASCII and Import Wizard (ORG-8706)
Here is the picture in Import wizard.
It's also supported in Import ASCII dialog. Partial Import node.
Set repetitive column designations in Import Wizard (ORG-8539)
With the following XY2Z designation, the imported columns will be XYZZXYZZ......
File: menu change: Moved Recent Import and Re-Import related Menus below Import menu
Statistics
Outlier tests (ORG-7936)
Grubbs Test and Dixon's Q-Test are added to Statistics: Descriptive Statistics menu.
More Power and Sample Size Test (ORG-7711, ORG-7712, ORG-7707, ORG-7706, ) – not all done yet
One-Proportion Test
Two-Proportion Test
One-Variance Test
Two Variance Test
Proportion Testing in Hypothesis Testing (ORG-7709 ORG-7710) – not all done yet
One-Sample Proportion Testing
Two-Sample Proportion Testing
t-Test on Rows
General Improvements
Arrange graph of same type in one graph in applicable statistics
More statistics quantities for Pair sample t test
Signal Processing
Two methods Lowess and Loess in smooth X-Function (ORG-6564)
Like matlab, SigmaPlot and Igor
An option Span Proportion should be available instead of Points of Window for it.
Interface
Smart Hint and Smart Hint Logs
In addition to the familiar Reminder popups, we have added a fading Smart Hint in places where the user may need some hint. If the user doesn't click on the hint, it will fade away.
E.g. we don't support smoothing on multiple Y datasets, but after doing smoothing on one dataset, there is faded hint to tell the user how to repeat analysis on all Y data.
There is also a Smart Hint Log window below the Messages Log where you can read smart hints displayed during the current session. You can also right click to search the hint in the Smart Hint Log window.
