管理Excel图表的轴
Contents
[
Hide
]
在Excel图表中,有3种类型的轴:
- 水平(类别)轴:X轴
- 垂直(值)轴:Y轴
- 深度(系列)轴:Z轴
轴选项
Aspose.Cells还允许在运行时管理图表的轴,使用 Axis 对象,可以像在Excel中一样更改轴的所有选项。
||
管理X和Y轴
在Excel图表中,水平和垂直轴是最常用的两种轴。
以下代码片段演示了如何设置X和Y轴的选项。
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// Instantiating a Workbook object | |
Workbook workbook = new Workbook(); | |
// Adding a new worksheet to the Workbook object | |
int sheetIndex = workbook.getWorksheets().add(); | |
// Obtaining the reference of the newly added worksheet by passing its sheet index | |
Worksheet worksheet = workbook.getWorksheets().get(sheetIndex); | |
// Adding sample values to cells | |
worksheet.getCells().get("A1").putValue("Series1"); | |
worksheet.getCells().get("A2").putValue(50); | |
worksheet.getCells().get("A3").putValue(100); | |
worksheet.getCells().get("A4").putValue(150); | |
worksheet.getCells().get("B1").putValue("Series2"); | |
worksheet.getCells().get("B2").putValue(60); | |
worksheet.getCells().get("B3").putValue(32); | |
worksheet.getCells().get("B4").putValue(50); | |
// Adding a chart to the worksheet | |
int chartIndex = worksheet.getCharts().add(ChartType.COLUMN, 5, 0, 15, 5); | |
// Accessing the instance of the newly added chart | |
Chart chart = worksheet.getCharts().get(chartIndex); | |
// Adding SeriesCollection (chart data source) to the chart ranging from "A1" cell to "B3" | |
chart.setChartDataRange("A1:B4",true); | |
//hiding X axis | |
chart.getCategoryAxis().setVisible(false); | |
// Setting max value of Y axis. | |
chart.getValueAxis().setMaxValue(200); | |
// Setting major unit. | |
chart.getValueAxis().setMajorUnit(50); | |
// Save the file | |
workbook.save("chart_axes.xlsx"); |