Daniel's XL Toolbox is a free, open-source add-in for Excel® that helps you to analyze and present data.
Export graphs in a format suitable for journal submission
TIFF, PNG, EMF;
black & white, grayscale, RGB, CMYK;
Export several graphs as one multi-panel figure, obviating the need for illustrator software.
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.
Visualize the true distribution of your data by automatically pull apart the data points in a grouped scatter plot.
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.
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.
Perform 1-way or 2-way Analysis of Variance (optionally with repeated measures) and posthoc tests.
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.
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.
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!
Choose which rows and columns to select from a larger range of cells: Use for table formatting, special copying tasks, etc.
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.
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.
Define paste actions that you can invoke with a keyboard shortcut.
Add, delete, rename, and move sheets in a convenient list rather than those flimsy tabs.
The XL Toolbox supports Undo for all features (within the limits of Excel).