image thumbnail

xlschart

version 1.0.0.0 (4.81 KB) by Fahad Al Mahmood
Writes column headers and a matrix to excel and graphs all columns or two specified columns.

7.6K Downloads

Updated 19 May 2004

View License

xlschart(titles,m,chartypechart_title,)
xlschart(titles,m,chartype,chart_title,filename)
xlschart(titles,m,chartype,chart_title,xtitle,ytitle)
xlschart(titles,m,chartype,chart_title,filename,sheetname)
xlschart(titles,m,chartype,chart_title,xtitle,ytitle,filename)
xlschart(titles,m,chartype,chart_title,xtitle,ytitle,filename,sheetname)

xlschart : writes column headers and a matrix to excel
and graphing all columns or 2 or more specified
columns using excel.

titles: Column titles (cell array).
m: matrix of numbers.
chartype: integer number corresponds to chart type.
chart_title: This title will be used for both chart sheet name and chart title.
filename: Name of excel file.
sheetname: sheet name.
xtitle: title of column to be x-axis (picked from titles).
ytitle: title(s) of column to be y-axis (picked from titles).

CHARTYPE:
1- ColumnClustered
2- ColumnStacked
3- ColumnStacked100
4- 3DColumnClustered
5- 3DColumnStacked
6- 3DColumnStacked100
7-3DColumn
8-BarClustered
9-BarStacked
10-BarStacked100
11-3DBarClustered
12-3DBarStacked
13-3DBarStacked100
14-Line
15-LineStacked
16-LineStacked100
17-LineMarkers
18-LineMarkersStacked
19-LineMarkersStacked100
20-3DLine
21-Pie
22-3DPie
23-PieOfPie
24-PieExploded
25-3DPieExploded
26-BarOfPie
27-XYScatter
28-XYScatterSmooth
29-XYScatterSmoothNoMarkers
30-XYScatterLines
31-XYScatterLinesNoMarkers
32-Area
33-AreaStacked
34-AreaStacked100
35-3DArea
36-3DAreaStacked
37-3DAreaStacked100
38-Doughnut
39-DoughnutExploded
40-Radar
41-RadarMarkers
42-RadarFilled
43-Surface
44-SurfaceWireframe
45-SurfaceTopView
46-SurfaceTopViewWireframe
47-Bubble
48-Bubble3DEffect
49-StockHLC
50-StockOHLC
51-StockVHLC
52-StockVOHLC

Examples:

titles = {'1st','2nd','3rd','4th','5th','6th','7th','8th','9th','10th'};
m = magic(10);
chart_title = 'My Title';
xlschart(titles,m,'LineStacked100',chart_title)
xlschart(titles,m,17,chart_title,'sample.xls','Sheet2');
xlschart(titles,m,'Line',chart_title,'1st','2nd','sample.xls','Sheet2');
xlschart(titles,m,20,chart_title,'1st','8th','sample.xls','Sheet2');
xlschart(titles,m,'XYScatterSmooth',chart_title,'10th','9th','sample.xls','Sheet2');
xlschart(titles,m,30,chart_title,'2nd',{'7th','6th'},'sample.xls','Sheet2');
xlschart(titles,m,29,chart_title,{'2nd','5th'},{'7th','6th'},'sample.xls','Sheet2');

See also XLSREAD, XLSFINFO, XLSWRITE, XLSCELL, XLSHEETS, , CPTXT2XLS, MSOPEN

Cite As

Fahad Al Mahmood (2021). xlschart (https://www.mathworks.com/matlabcentral/fileexchange/4585-xlschart), MATLAB Central File Exchange. Retrieved .

MATLAB Release Compatibility
Created with R13
Compatible with any release
Platform Compatibility
Windows macOS Linux

Community Treasure Hunt

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

Start Hunting!