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

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.

Answers (1)

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.

Asked:

on 29 Jun 2015

Answered:

on 29 Jun 2015

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!