Add second y-axis to excel plot

Question

Ellie 2012-10-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/50627-add-second-y-axis-to-excel-plot

回答： Julian Hapke 2014-6-23

Chart = invoke(Workbook.Charts,'Add');
Chart.ChartType = 'xlXYScatterSmooth';
Chart.Axes(1).HasTitle = true;
Chart.Axes(1).AxisTitle.Text = 'Time (sec)';
Chart.Axes(2).HasTitle = true;
Chart.Axes(2).AxisTitle.Text = 'Pressure (psig/psid)';
Chart.Axes(2,2).HasTitle = true;
Chart.Axes(2,2).AxisTitle.Text = 'RPM and Flows (pph)';
invoke(Chart, 'SetSourceData', Excel.Range('Sheet1!A3:D6'));

If I use:

Chart.Axes(2,2).HasTitle = true;
Chart.Axes(2,2).AxisTitle.Text = 'RPM and Flows (pph)';

to obtain the second y axis, I get the following message:

Error using Interface.000208D6_0000_0000_C000_000000000046/Axes
Invoke Error, Dispatch Exception: Unspecified error
Error in Trial (line 14)
Chart.Axes(2,2).HasTitle = true;

How can a second y-axis be added to the right of the chart?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Julian Hapke 2014-6-23

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/50627-add-second-y-axis-to-excel-plot#answer_142065

在 MATLAB Online 中打开

hi anda,

if you have data in your chart, that's supposed to be scaled to the secondary y-axis, just move the plot there, here's an example:

xls = actxserver('Excel.Application');
xls.Visible=true;
a=num2cell([(1:10)' (1:10)' (10.^(1:10))']);
wb=xls.Workbooks.Add;
set(wb.ActiveSheet.Range('$A$1:$C$10'),'Value',a);
crt=wb.ActiveSheet.Shapes.AddChart(75);
getscale(crt)
s2=crt.Chart.SeriesCollection(2);
set(s2,'AxisGroup','xlSecondary');