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

1 visualizzazione (ultimi 30 giorni)
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.

Risposte (1)

Guillaume
Guillaume il 29 Giu 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.

Categorie

Scopri di più su Use COM Objects in MATLAB in Help Center e File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by