Plotting Excel graph Using Matlab
3 views (last 30 days)
Show older comments
I would like to take an existing excel spreadsheet and use Matlab to create charts from the data in the spreadsheet.
The purpose to to have a script that will quickly create the same charts for each sheet. Please advise.
0 Comments
Answers (1)
Image Analyst
on 27 May 2014
Where will the charts live? In the workbook, or in your MATLAB GUI? If they are to live in the workbook, it's easiest to have charts made up in advance and you just populate the cells with new data. If you have to create them from scratch, you're in for a world of fun using ActiveX.
2 Comments
Image Analyst
on 28 May 2014
Can you make up a macro in Excel to create the chart and save it with the workbook? This is easiest since you do everything in Excel and all you have to do from MATLAB is to run the Excel macro.
Otherwise you'll have to examine the macro and try to translate those same commands into Excel. It will be almost like the ActiveX commands that you'd use in Excel but slightly different.
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!