Is it possible to plot a scatter graph in excel, with 2 separate y axes, using matlab?

Question

George Atkinson on 29 Jun 2015

0
Link

Direct link to this question

https://www.mathworks.com/matlabcentral/answers/225756-is-it-possible-to-plot-a-scatter-graph-in-excel-with-2-separate-y-axes-using-matlab

Answered: Guillaume on 29 Jun 2015

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
Show -2 older commentsHide -2 older comments

Sign in to comment.

Sign in to answer this question.

Answer 1

Guillaume on 29 Jun 2015

0
Link

Direct link to this answer

https://www.mathworks.com/matlabcentral/answers/225756-is-it-possible-to-plot-a-scatter-graph-in-excel-with-2-separate-y-axes-using-matlab#answer_184388

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.