Is it possible to plot a scatter graph in excel, with 2 separate y axes, using matlab?
조회 수: 1 (최근 30일)
이전 댓글 표시
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
답변 (1개)
Guillaume
2015년 6월 29일
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
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!