Export graphs in a format suitable for journal submission

TIFF, PNG, EMF;
black & white, grayscale, RGB, CMYK;
100-2400 DPI;

Export several graphs as one multi-panel figure, obviating the need for illustrator software.

Chart design

Apply your own professional style to your graphs with a few mouse clicks. No more thin blue lines on a gray background!

"Smart" custom error bars:

Apply error bars to your bar/column and line/scatter plots. Features: Smart placement & formatting.

Spread scatter

Visualize the true distribution of your data by automatically pull apart the data points in a grouped scatter plot.

Annotate charts

Add annotations from spreadsheet cell comments to a chart.

Highlight individual data points by applying color from source cells.

Move or extend chart range

Browse through your data, and append new data to an existing chart.

Quick save chart(s)

Save the selected chart or all charts in a worksheet/workbook to graphic files.

Copy chart format

Select style features of a chart and copy them to other charts in your worksheet/workbook.

Chart watermarks

Add your initials, the current date, or any other information to a chart.

Change chart size

Set the chart size in inches, millimeters, or points in Excel 2000-2003.

Point chart to sheet

When copying & pasting a chart from one worksheet to another, the chart may still reference data on the original worksheet. Use this function to quickly fix this problem.

Autoscale chart font (Excel 2003 only)

Enable or disable automatic font adjustment when a chart is resized.

Add many chart series

Add many series at once to a chart.

Promote/demote chart series

Move chart series to the foreground or background easily.

ANOVA

Perform 1-way or 2-way Analysis of Variance (optionally with repeated measures) and posthoc tests.

Formula builder

The formula builder collects cell references for your data to create formulas – averages, standard errors, etc.

Group allocation ("randomization")

Allocate study subjects to treatment groups according to baseline criteria.

Linear regression

Perform linear regression analysis and optionally compare slopes and intercepts of several regressions. Test the statistical significance of the regression(s).

Pearson product-moment coefficient

Perform linear correlation analysis and calculate the Pearson product-moment coefficient. Test the statistical significance of the correlation.

Transpose data

Reorganize any data from table format to a list. Optionally calculates averages and SD/SEM for you. Great for plate readers & PCR output in the life sciences!

Selection Assistant

Choose which rows and columns to select from a larger range of cells: Use for table formatting, special copying tasks, etc.

Histogram

Calculate frequencies from your data. The "multi" in Multi Histogram means that you can combine several columns of data into one histogram – useful when analyzing several fields of view in a microscope.

Automatic backups

Keep backup copies of your Excel files: Several versions per day, and one additional copy for the most recent couple of days.

Copy page setup

Copy headers, footers, margins, paper size, and other properties of the page setup from the current sheet to the other sheets in the workbook.

Special paste

Define paste actions that you can invoke with a keyboard shortcut.

Sheet management

Add, delete, rename, and move sheets in a convenient list rather than those flimsy tabs.

Undo

The XL Toolbox supports Undo for all features (within the limits of Excel).