Plotting Excel graph Using Matlab

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.

Answer 1

[Image Analyst]

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.

[Russell]

The chart will be in the workbook.

[Image Analyst]

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.