No appropriate method, property, or field AddChart for class Interface error?

2014 8 12
2 个回答
更新时间：2021 8 17
1 次查看（30 天）

0 个投票

I recently updated from Excel 2007 to Excel 2013 and I am now having issues running my code. I ran the code on an older computer with older MS software and no issues. The error is shown below:
try
Select(Range(EXCEL,sprintf('%s',range))); %select cells
EXCEL.ActiveSheet.Shapes.AddChart.Select;
The error is: No appropriate method, property, or field AddChart for class Interface.0002443A_0000_0000_C000_000000000046.
set(EXCEL.ActiveChart,'ChartType',90);
catch ME
beep;
fprintf('There may be too many Item types for the charting to work properly!\r\r');
disp(getReport(ME));
break;
end
Maybe someone has had this problem and can help. Thanks

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

回答（2 个）

Thiago Motta
Thiago Motta 2016-10-14

2 个投票

Hello
I have Excel 2013 and the following works for me:
Chart = Excel.ActiveSheet.Shapes.AddChart2;
According to this Shapes.AddChart doesnt exists, but Shapes.AddChart2 exists.

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

iitm_pnkj
iitm_pnkj 2021-8-17
I need solution for this
https://in.mathworks.com/matlabcentral/answers/1413147-how-to-find-and-replace-text-provided-in-a-textbox-in-a-docx-file

请先登录，再进行评论。

Tarik Khoury
Tarik Khoury 2015-12-7

0 个投票

Hello Laszlo,
I have the same issue. Did you find a solution for your issue?
Thanks

类别

在 帮助中心 和 File Exchange 中查找有关 Line Plots 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by