Excel plot generator

Generate plots in Excel directly from MATLAB
325 Downloads
Updated 30 Oct 2016

View License

This application generates plots in Excel from the MATLAB environment with no requirement to open and process the data in Excel. Application is intended to function like the internal MATLAB plot command by using handles to modify the data location / plot formatting. The major difference is that modifications are declared before the file is generated rather than by modifying the object afterward as is done in MATLAB. See help for examples.
Application uses active X (with all the limitations associated there in). But by using active X, MATLAB can modify the Excel plots as needed and it is faster than xlswrite. You can add to existing Excel files if you like but behaviors can be a little strange if you accidently overwrite existing data. NOTICE: Active X has demonstrated some instability in testing. Some machines work fine while others require Excel to be closed when using the program. It is an Active X issue, not a MATLAB issue.
If you find yourself forced to provide data using the least common denominator of programming languages (Excel), this is a relatively simple way to write data to excel and generate plots from that data into a self-contained Excel workbook. User does not need MATALB and will not be able to tell that MATLAB was used to generate the data.

Cite As

michael arant (2024). Excel plot generator (https://www.mathworks.com/matlabcentral/fileexchange/52745-excel-plot-generator), MATLAB Central File Exchange. Retrieved .

MATLAB Release Compatibility
Created with R2012a
Compatible with any release
Platform Compatibility
Windows macOS Linux

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!
Version Published Release Notes
1.2.0.0

Now error traps windows com issues (active X failures)

1.1.0.0

now handles user defined axis limits and axis crossing locations.

1.0.0.0