Plot data in excel on saved chart template
3 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
I am trying to plot data in Excel from Matlab onto a chart template that I saved from Excel. I tried manipulating the VBA code to load the template which is
eW.ActiveSheet.Shapes.AddChart.Select;
eWs.ActiveChart.ApplyChartTemplate('C:...')
but I error out saying AddChart and ApplyChartTemplate is not a command. I have a feeling that I can do this with invoke but have had no luck trying something like this
template = 'C:....';
% Add a chart to the workbook
Chart = invoke(Excel,'ApplyTemplate',template);
Has anyone ever loaded a chart template and plotted to it successfully?
0 Kommentare
Antworten (0)
Siehe auch
Kategorien
Mehr zu Data Import from MATLAB finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!