Publisher review:xlsgraph creates graphs from existing Excel sheet containing column data. 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- ColumnClustered2- ColumnStacked3- ColumnStacked1004- 3DColumnClustered5- 3DColumnStacked6- 3DColumnStacked100 7-3DColumn8-BarClustered9-BarStacked10-BarStacked10011-3DBarClustered12-3DBarStacked13-3DBarStacked10014-Line15-LineStacked16-LineStacked10017-LineMarkers18-LineMarkersStacked19-LineMarkersStacked10020-3DLine21-Pie22-3DPie23-PieOfPie24-PieExploded25-3DPieExploded26-BarOfPie27-XYScatter28-XYScatterSmooth29-XYScatterSmoothNoMarkers30-XYScatterLines31-XYScatterLinesNoMarkers32-Area33-AreaStacked34-AreaStacked10035-3DArea36-3DAreaStacked37-3DAreaStacked10038-Doughnut39-DoughnutExploded40-Radar41-RadarMarkers42-RadarFilled43-Surface44-SurfaceWireframe45-SurfaceTopView46-SurfaceTopViewWireframe47-Bubble48-Bubble3DEffect49-StockHLC50-StockOHLC51-StockVHLC52-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 Requirements: ยท MATLAB Release: R13
xlsgraph is a Matlab script for Scientific/Engineering scripts design by Fahad Al Mahmood.
It runs on following operating system: Windows / Linux / Mac OS / BSD / Solaris.
xlsgraph creates graphs from existing Excel sheet containing column data.
Operating system:Windows / Linux / Mac OS / BSD / Solaris