Z轴
Contents
[
Hide
]
可能的使用场景
对于一些具有深度(系列)轴的3D图表,例如3D柱状图、3D圆锥体图或3D金字塔图,也称为Z轴,您可以进行更改。您可以指定刻度标记之间的间隔、轴标签和其他操作。
处理主轴和第二轴,就像处理Microsoft Excel一样
请参阅以下示例代码,创建一个新的Excel文件,并在第一个工作表中放置图表的值。然后我们添加一个图表并将图表类型设置为3D柱状图,然后您就可以看到Z轴,也称为深度轴。
示例代码
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
// Create an instance of Workbook | |
Workbook workbook = new Workbook(); | |
// Get the first worksheet | |
Worksheet worksheet = workbook.Worksheets[0]; | |
// Put values to cells for creating chart | |
worksheet.Cells["A1"].PutValue("A"); | |
worksheet.Cells["B1"].PutValue("B"); | |
worksheet.Cells["C1"].PutValue("C"); | |
worksheet.Cells["A2"].PutValue(2); | |
worksheet.Cells["A3"].PutValue(1); | |
worksheet.Cells["B2"].PutValue(2); | |
worksheet.Cells["B3"].PutValue(3); | |
worksheet.Cells["C2"].PutValue(2); | |
worksheet.Cells["C3"].PutValue(3); | |
// Add a chart to the worksheet | |
int chartIndex = worksheet.Charts.Add(Aspose.Cells.Charts.ChartType.Column3D, 9, 6, 25, 16); | |
// Access the instance of the newly added chart | |
Aspose.Cells.Charts.Chart chart = worksheet.Charts[chartIndex]; | |
// Calculate the hart | |
chart.Calculate(); | |
// Add SeriesCollection (chart data source) to the chart ranging from "A2" cell to "C3" | |
chart.SetChartDataRange("A2:C3", true); | |
// Hide the CategoryAxis axis | |
chart.CategoryAxis.IsVisible = false; | |
// Hide the ValueAxis axis | |
chart.ValueAxis.IsVisible = false; | |
// Save the file | |
workbook.Save("ZAxis.xlsx"); |