View License

Download apps, toolboxes, and other File Exchange content using Add-On Explorer in MATLAB.

» Watch video

Highlights from
Excel Embedded chart.

4.0 | 1 rating Rate this file 6 Downloads (last 30 days) File Size: 93.1 KB File ID: #33046 Version: 1.0
image thumbnail

Excel Embedded chart.



create an embedded chart in excel from data in excel spreadsheet.

| Watch this File

File Information

this function provides embedded charts in excel from data already present and saved in excel.
1) download the zip file here.
2) open test1.m and set the address of test1.xlsx accordingly.
3) run test1.m, DONE.

once you get round to what the function is capable of then, it is open to you to modify it the way you want it.

note: this function does not save the excel spreadsheet, but it is rather easy to do that any way.
also you can write and modify the function to what ever extent you want... i have left this here to users, any problems or questions let me know.


MATLAB release MATLAB 7.13 (R2011b)
Tags for This File   Please login to tag files.
Please login to add a comment or rating.
Comments and Ratings (3)
08 Nov 2016 CoreyAcker

I got this to work using MATLAB 2014a, Excel 2013 in Windows 7 by replacing
"AddChart" with "AddChart2" in EmChartObj. I noticed use of AddChart2 when I inspected some excel macros. None of this changes the fact that excel graphs (aka "charts", are we sailing?) are very ugly.

31 Mar 2012 rasam aliazizi

there are currently no books or written document, to my knowledge! there are however very limited code examples on mathwork web site that you need to search for it, including xlswrite and xlsread. other than that it is just spending time, and look for examples like this in file exchange, that is the best i can give you. also i have written a function that does a lot more on excel and i will upload that soon, this will be a good example to follow for you.

Comment only
26 Mar 2012 w sq

w sq (view profile)

well done. Can you recommend me some books about using microsoft Excel in matlab?

I have some questions about Excel, See my Ask 'program skills about Microsoft Excel, Word and so on' if you have any interest.


Comment only

Contact us