Excel.ChartType enum
Remarques
[ Ensemble d’API : ExcelApi 1.1 ]
Exemples
// 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();
});
Champs
_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" |
Collaborer avec nous sur GitHub
La source de ce contenu se trouve sur GitHub, où vous pouvez également créer et examiner les problèmes et les demandes de tirage. Pour plus d’informations, consultez notre guide du contributeur.
Commentaires
https://aka.ms/ContentUserFeedback.
Bientôt disponible : Tout au long de 2024, nous allons supprimer progressivement GitHub Issues comme mécanisme de commentaires pour le contenu et le remplacer par un nouveau système de commentaires. Pour plus d’informations, consultezEnvoyer et afficher des commentaires pour