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
- Plots X-Y-Z scatter graphs, line graphs, voxel and bar charts, 2.5D surfaces (TIN or gridded mesh), 2.5D contours， 3D surface and water tight solids from point clouds;
- Exports high-resolution image or AVI videos;
- Supports for 3D cartesian, polar(cylindrical) and spherical plots;
- Includes both uniform scaling (for presentation graphs) and non-uniform scaling (for engineering drawings) modes;
- Includes a wide variety of customization options for chart/graph display, including Wireframe Overlay , and Date/Time data type etc.
- Supports real-time graph updates on cell changes;
- Supports VBA scripting;
- Works with Excel 2000 and all later Excel Versions.
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:
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.