xlsgraph (xtitle ytitle、chartype chart_title,文件名,sheetname)

xlsgraph:创建一个Excel图表通过搜索指定表选定的列标题。

xtitle:标题(s)的柱轴(从标题)。

ytitle:标题(s)的柱轴(从标题)。

chartype:整数对应图表类型(从下面的列表)的字符或字符串名称的图表类型(交货。“3 dline”)

chart_title:这个标题将用于图表名称和表标题。

文件名:excel文件的名字。

sheetname:表名。

CHARTYPE:
1 - ColumnClustered
2 - ColumnStacked
3 - ColumnStacked100
4 - 3 dcolumnclustered
5 - 3 dcolumnstacked
6 - 3 dcolumnstacked100
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

例子:

xlsgraph (‘col_1’,‘col_2’,‘XYScatterSmooth’,‘1和2’,‘data.xls’,‘数据’);
xlsgraph (‘col_1’,‘col_4’,‘XYScatterSmooth’,‘1和4’,‘data.xls’,‘数据’);
xlsgraph ({‘col_1’,‘col_2}, {‘col_3’,‘col_4},“行”,“1、2点和3和4”,“data.xls”,“数据”);

参见XLSREAD、XLSFINFO XLSWRITE、XLSCELL XLSHEETS, MSOPEN XLSCHART