Is it possible to plot a scatter graph in excel, with 2 separate y axes, using matlab?
1 view (last 30 days)
Show older comments
I am curious as to whether this is possible, as individuals I work with are more familiar with excel than matlab and thus if anything were to go wrong with the code they could fall back on the excel data.
0 Comments
Answers (1)
Guillaume
on 29 Jun 2015
Anything that can be done in Excel is available through excel COM api. Since matlab supports COM interfaces and since it's possible to create graphs with two y axes in excel the answer is "Yes".
You'll have to figure out the correct sequence of calls to excel. The simplest to achieve that might to record a macro in excel where you construct the graph and translate that in the appropriate COM methods.
0 Comments
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!