Excel.ChartType enum
Comentarios
[ Conjunto de API: ExcelApi 1.1 ]
Ejemplos
// Link to full sample: https://raw.githubusercontent.com/OfficeDev/office-js-snippets/prod/samples/excel/10-chart/chart-create-several-charts.yaml
await Excel.run(async (context) => {
let sheet = context.workbook.worksheets.getItem("Sample");
let salesTable = sheet.tables.getItem("SalesTable");
let dataRange = sheet.getRange("A1:E7");
let chart = sheet.charts.add(Excel.ChartType.line, dataRange, "Auto");
chart.setPosition("A22", "F35");
chart.legend.position = "Right";
chart.legend.format.fill.setSolidColor("white");
chart.dataLabels.format.font.size = 15;
chart.dataLabels.format.font.color = "black";
chart.title.text = "Bicycle Parts Quarterly Sales";
await context.sync();
});
Campos
| _3DArea = "3DArea" | |
| _3DAreaStacked = "3DAreaStacked" | |
| _3DAreaStacked100 = "3DAreaStacked100" | |
| _3DBarClustered = "3DBarClustered" | |
| _3DBarStacked = "3DBarStacked" | |
| _3DBarStacked100 = "3DBarStacked100" | |
| _3DColumn = "3DColumn" | |
| _3DColumnClustered = "3DColumnClustered" | |
| _3DColumnStacked = "3DColumnStacked" | |
| _3DColumnStacked100 = "3DColumnStacked100" | |
| _3DLine = "3DLine" | |
| _3DPie = "3DPie" | |
| _3DPieExploded = "3DPieExploded" | |
| area = "Area" | |
| areaStacked = "AreaStacked" | |
| areaStacked100 = "AreaStacked100" | |
| barClustered = "BarClustered" | |
| barOfPie = "BarOfPie" | |
| barStacked = "BarStacked" | |
| barStacked100 = "BarStacked100" | |
| boxwhisker = "Boxwhisker" | |
| bubble = "Bubble" | |
| bubble3DEffect = "Bubble3DEffect" | |
| columnClustered = "ColumnClustered" | |
| columnStacked = "ColumnStacked" | |
| columnStacked100 = "ColumnStacked100" | |
| coneBarClustered = "ConeBarClustered" | |
| coneBarStacked = "ConeBarStacked" | |
| coneBarStacked100 = "ConeBarStacked100" | |
| coneCol = "ConeCol" | |
| coneColClustered = "ConeColClustered" | |
| coneColStacked = "ConeColStacked" | |
| coneColStacked100 = "ConeColStacked100" | |
| cylinderBarClustered = "CylinderBarClustered" | |
| cylinderBarStacked = "CylinderBarStacked" | |
| cylinderBarStacked100 = "CylinderBarStacked100" | |
| cylinderCol = "CylinderCol" | |
| cylinderColClustered = "CylinderColClustered" | |
| cylinderColStacked = "CylinderColStacked" | |
| cylinderColStacked100 = "CylinderColStacked100" | |
| doughnut = "Doughnut" | |
| doughnutExploded = "DoughnutExploded" | |
| funnel = "Funnel" | |
| histogram = "Histogram" | |
| invalid = "Invalid" | |
| line = "Line" | |
| lineMarkers = "LineMarkers" | |
| lineMarkersStacked = "LineMarkersStacked" | |
| lineMarkersStacked100 = "LineMarkersStacked100" | |
| lineStacked = "LineStacked" | |
| lineStacked100 = "LineStacked100" | |
| pareto = "Pareto" | |
| pie = "Pie" | |
| pieExploded = "PieExploded" | |
| pieOfPie = "PieOfPie" | |
| pyramidBarClustered = "PyramidBarClustered" | |
| pyramidBarStacked = "PyramidBarStacked" | |
| pyramidBarStacked100 = "PyramidBarStacked100" | |
| pyramidCol = "PyramidCol" | |
| pyramidColClustered = "PyramidColClustered" | |
| pyramidColStacked = "PyramidColStacked" | |
| pyramidColStacked100 = "PyramidColStacked100" | |
| radar = "Radar" | |
| radarFilled = "RadarFilled" | |
| radarMarkers = "RadarMarkers" | |
| regionMap = "RegionMap" | |
| stockHLC = "StockHLC" | |
| stockOHLC = "StockOHLC" | |
| stockVHLC = "StockVHLC" | |
| stockVOHLC = "StockVOHLC" | |
| sunburst = "Sunburst" | |
| surface = "Surface" | |
| surfaceTopView = "SurfaceTopView" | |
| surfaceTopViewWireframe = "SurfaceTopViewWireframe" | |
| surfaceWireframe = "SurfaceWireframe" | |
| treemap = "Treemap" | |
| waterfall = "Waterfall" | |
| xyscatter = "XYScatter" | |
| xyscatterLines = "XYScatterLines" | |
| xyscatterLinesNoMarkers = "XYScatterLinesNoMarkers" | |
| xyscatterSmooth = "XYScatterSmooth" | |
| xyscatterSmoothNoMarkers = "XYScatterSmoothNoMarkers" |