确定图表中存在哪个轴

以下示例代码演示了如何使用Chart.HasAxis(AxisType axisType, bool isPrimary)来确定示例图表是否具有主要和次要类别和值轴。

用于确定图表中存在哪些轴的C#代码

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
// Create workbook object
Workbook workbook = new Workbook(dataDir + "source.xlsx");
// Access the first worksheet
Worksheet worksheet = workbook.Worksheets[0];
// Access the chart
Chart chart = worksheet.Charts[0];
//Determine which axis exists in chart
bool ret = chart.HasAxis(AxisType.Category, true);
Console.WriteLine("Has Primary Category Axis: " + ret);
ret = chart.HasAxis(AxisType.Category, false);
Console.WriteLine("Has Secondary Category Axis: " + ret);
ret = chart.HasAxis(AxisType.Value, true);
Console.WriteLine("Has Primary Value Axis: " + ret);
ret = chart.HasAxis(AxisType.Value, false);
Console.WriteLine("Has Secondary Value Axis: " + ret);

示例代码生成的控制台输出

代码的控制台输出如下所示,显示主类别和值轴为true,次要类别和值轴为false。

Has Primary Category Axis: True

Has Secondary Category Axis: False

Has Primary Value Axis: True

Has Secondary Value Axis: False