xlsgraph
xlsgraph(xtitle,ytitle,chartype,chart_title,filename,sheetname)
xlsgraph : creates an Excel graph by searching specified sheet for selected columns headers.
xtitle: title(s) of column to be x-axis (picked from titles).
ytitle: title(s) of column to be y-axis (picked from titles).
chartype: integer number corresponds to chart type (from the list below) or string of characters to name the chart type (ex. '3DLine')
chart_title: This title will be used for both chart sheet name and chart title.
filename: Name of excel file.
sheetname: sheet name.
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:
xlsgraph('col_1','col_2','XYScatterSmooth','1 vs 2','data.xls','Data');
xlsgraph('col_1','col_4','XYScatterSmooth','1 vs 4','data.xls','Data');
xlsgraph({'col_1','col_2'},{'col_3','col_4'},'Line','1&2 vs 3&4','data.xls','Data');
See also XLSREAD, XLSFINFO, XLSWRITE, XLSCELL, XLSHEETS, MSOPEN, XLSCHART
引用格式
Fahad Al Mahmood (2024). xlsgraph (https://www.mathworks.com/matlabcentral/fileexchange/5025-xlsgraph), MATLAB Central File Exchange. 检索来源 .
MATLAB 版本兼容性
平台兼容性
Windows macOS Linux类别
- MATLAB > Data Import and Analysis > Data Import and Export > Standard File Formats > Spreadsheets >
- MATLAB > External Language Interfaces > COM with MATLAB > Use COM Objects in MATLAB >
标签
致谢
参考作品: xlschart
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!版本 | 已发布 | 发行说明 | |
---|---|---|---|
1.0.0.0 | Added subfunction (xlscolumn) to the main function. |