Plot data in excel on saved chart template
2 views (last 30 days)
Show older comments
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 Comments
Answers (0)
See Also
Categories
Find more on Data Import from MATLAB in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!