xlsgraph

バージョン 1.0.0.0 (9.41 KB) 作成者: Fahad Al Mahmood
Creates graphs from existing Excel sheet containing column data.

ダウンロード 5.2K 件

更新 2004/6/30

ライセンスの表示

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 (2022). xlsgraph (https://www.mathworks.com/matlabcentral/fileexchange/5025-xlsgraph), MATLAB Central File Exchange. 取得済み .

MATLAB リリースの互換性
作成: R13
すべてのリリースと互換性あり
プラットフォームの互換性
Windows macOS Linux
謝辞

ヒントを得たファイル: xlschart

Community Treasure Hunt

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

Start Hunting!