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

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

Answer 1

[Thiago Motta]

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.

[iitm_pnkj]

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

Answer 2

[Tarik Khoury]

Hello Laszlo,

I have the same issue. Did you find a solution for your issue?

Thanks