XLGrapher - Creates XYZ Scatter Graphs, Charts, and CAD objects in Excel

Deployed as an add-in for Microsoft Excel, ThreeDify Excel Grapher (XLGrapher) makes 3D graphing and plotting as easy as highlighting a range of cells in a worksheet. With a few mouse clicks, you can easily create a wide range of X-Y-Z scatter graphs, line graphs, 3D voxel and bar charts, Cartesian, polar and spherical plots, surfaces (TIN and gridded meshes) as well as water-tight solids. Excel Grapher is totally integrated with MS Excel and it runs completely inside the familiar Excel interface. The created 3D graphs and fitted equations are saved as part of Excel workbooks. That means there’s no need to run a separate application and there are no external files or additional file formats to manage.

Key Features

XLGrapher Feature List

Screenshots

System Requirements:

OS: Windows 7, 8.1 or 10
Space: 8.3 MB
Additional Requirements: Microsoft Excel 2000 or better installed

Testimonials:

“I have been impressed not only with this software but also the support …… and I’ve received quick responses to my emails—and even a phone call once to help me.”
Terry Grapentine
President, Grapentine Company LLC

Include over 2500 3D equations that are divided into 15 equation families: Polynomial, Rational, Exponential, Power, Logarithmic, Bioscience, Optical, Peak, NIST, Taylor Series, Sigmoidal, Simple, Trigonometric, Enzyme Kinetics, and Miscellaneous.

Automatically sort and plot the fitted equations by the statistical criteria you select in Excel (r2, DOF adjusted r2, Fit Standard Error or the F Statistic). Graphically review the fitted results as user scroll through the equation list. A 3D residuals graph as well as parameter output are generated for each fitted equation.

Plot multiple graph series inside Excel directly from user-specified cell ranges within MS Excel (when used as an Excel Addin only). The cell ranges can be specified from a single worksheet of the active workbook or from different worksheets in different open workbooks,allowing maximum flexibility in specifying input data for plotting.

Easily specify X, Y, Z cell ranges in MS Excel to plot with mouse or keyboard selection. The specified cell ranges do not have to be of the same dimension or size. They will be auto-resized.

Generation of 2D and 3D gridded meshes or water-tight solids from unorganized points directly inside MS Excel.

Modifiable linear or radial color gradient background.

Animation export to AVI video formats.

Ability to Zoom, Pan (by middle mouse drag) and Spin (with an Arcball interface) and animate the graphs.

Support for different plot styles for each graph series: Points, Lines, Voxel, Bar, TIN, Gridded Mesh, Solids or combination of several styles, as well as wireframe overlay and transparent mode.

Basic 4D data visualization directly within Excel.

Support for numerical and date/time data types.

Support 3D Cartesian, Polar(Cylindrical) and Spherical plots in both uniform scaling (for presentation graphs) and non-uniform scaling (for engineering drawing) modes.

Support two camera modes:Orthographic and Perspective.

Flexible data scaling option for both presentation graphs and engineering drawings.

Axis customization, including customizable grid spacing, font, colors, and axis labels.

Ability to export graph surfaces and/or solids to VRML v2 format.

Real-time graph update on cell change.

Export to image files of user-specified size and format: *.bmp, *.exr, *.gif, *.hdr, *.ico, *.jpg, *.jpg2, *.jpc, *jpeg, *.pfm, *.png, *.pbm, *.pgm, *ppm, *.tga, *.tif, *.xpm.

Automation through VB and VBA.