通过

Excel.ChartType enum

  • 参考
包:
excel

注解

[ API 集：ExcelApi 1.1 ]

示例

// 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();
});

字段

_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"