主轴和次轴
Contents
[
Hide
]
可能的使用场景
当图表中的数据系列之间的数值差异很大,或者当您有多种类型的数据(价格和成交量)时,请在次垂直(值)轴上绘制一个或多个数据系列。次垂直轴的刻度显示了相关数据系列的值。在显示柱形图和折线图的组合图中,次要轴效果很好。
处理主轴和第二轴,就像处理Microsoft Excel一样
请参阅以下样本代码,创建一个新的Excel文件并在第一个工作表中放置图表的值。 然后我们添加一个图表并显示第二轴。
示例代码
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(); | |
// Access the first worksheet. | |
Worksheet worksheet = workbook.Worksheets[0]; | |
// Put the sample values used in a chart | |
worksheet.Cells["A1"].PutValue("Region"); | |
worksheet.Cells["A2"].PutValue("Peking"); | |
worksheet.Cells["A3"].PutValue("New York"); | |
worksheet.Cells["A4"].PutValue("Paris"); | |
worksheet.Cells["B1"].PutValue("Sales Volume"); | |
worksheet.Cells["C1"].PutValue("Growth Rate"); | |
worksheet.Cells["B2"].PutValue(100); | |
worksheet.Cells["B3"].PutValue(80); | |
worksheet.Cells["B4"].PutValue(140); | |
worksheet.Cells["C2"].PutValue(0.7); | |
worksheet.Cells["C3"].PutValue(0.8); | |
worksheet.Cells["C4"].PutValue(1.0); | |
// Create a Scatter chart | |
int pieIdx = worksheet.Charts.Add(ChartType.Scatter, 6, 6, 15, 11); | |
// Retrieve the Chart object | |
Chart chart = worksheet.Charts[pieIdx]; | |
// Add Series | |
chart.NSeries.Add("B2:C4", true); | |
// Set the category data | |
chart.NSeries.CategoryData = "=Sheet1!$A$2:$A$4"; | |
// Set the Second-Axis | |
chart.NSeries[1].PlotOnSecondAxis = true; | |
// Show the Second-Axis | |
chart.SecondValueAxis.IsVisible = true; | |
// Set the second series ChartType to line | |
chart.NSeries[1].Type = Aspose.Cells.Charts.ChartType.Line; | |
// Set the series name | |
chart.NSeries[0].Name = "Sales Volume"; | |
chart.NSeries[1].Name = "Growth Rate"; | |
// Set the Legend at the bottom of the chart area | |
chart.Legend.Position = LegendPositionType.Bottom; | |
// Fill the PlotArea area with nothing | |
chart.PlotArea.Area.FillFormat.FillType = FillType.None; | |
// Save the file | |
workbook.Save("PrimaryandSecondaryAxis.xlsx"); |