How to set programmatically set ScaleType to Logarithmic in Excel Plot

Question

Scott 2022-8-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1786650-how-to-set-programmatically-set-scaletype-to-logarithmic-in-excel-plot

回答： Rohit Kulkarni 2023-8-31

I have code that successfully opens an Excel workbook in office 365 and plots data in an XYScatter plot. However, I wish for both the X and Y axes to have logarithmic scales but unfortunatley I cannot find the correct enumeration with what I believe is the correct axes property "ScaleType". I have tried two alternative enumerations:

ScaleType = 'xlLogarithmic' For this I get the error "There is no enumerated value named 'xlLogarithmic'."
ScaleType = 'xlScaleLogarithmic'; For this I get the error "Invoke Error, Dispatch Exception: Unspecified error

Here is my code

excelApp = actxserver('Excel.Application');

myWorkBook = excelApp.workbooks.Add;

workSheets = myWorkBook.Sheets;

myWorkSheet = excelApp.Activesheet ;

line{1} = myPlots.SeriesCollection.NewSeries;

myPlots.SeriesCollection(1).XValue = myWorkSheet.Range('A2:A24');

myPlots.SeriesCollection(1).Values = myWorkSheet.Range('B2:B24');

line{1}.ChartType = 'xlXYScatterLinesNoMarkers';

%Below is where i get the error for either approach

myPlots.Axes(1).ScaleType = 'xlLogarithmic';

myPlots.Axes(1).ScaleType = 'xlScaleLogarithmic';

Any suggestions?

Thanks

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

请先登录，再进行评论。

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

Answer 1

Rohit Kulkarni 2023-8-31

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1786650-how-to-set-programmatically-set-scaletype-to-logarithmic-in-excel-plot#answer_1298186

在 MATLAB Online 中打开

Hi Scott,

I understand that you are facing the error in using the ScaleType property. According to the Excel Documentation there are two xlScaleType enumerations, xlScaleLinear and xlScaleLogarithmic.

xlScaleLogarithmic is used to set the scale to logarithmic.

Use xlScaleLogarithmic in the following way:

myPlots("myPlot1").Axes(xlValue).ScaleType =xlScaleLogarithmic

This will set the value axis in myPlot1 to use a logarithmic scale.

Refer the documentation link for details:

https://learn.microsoft.com/en-us/previous-versions/office/developer/office-2007/bb221595(v=office.12)

Hope it helps!