X轴与分类轴的区别

可能的使用场景

X轴有不同类型。而Y轴是一个值类型轴，X轴可以是分类类型轴或值类型轴。使用值轴，数据被视为连续变化的数值数据，并且标记位于沿轴的变动点，其位置根据其数值而变化。使用分类轴，数据被视为一系列非数值文本标签，并且标记位于沿轴的一个位置，其位置根据其在序列中的位置而变化。下面的示例说明了值轴和分类轴之间的区别。 我们的示例数据如下图中的示例表文件所示。第一列包含我们的X轴数据，可以视为分类或值。请注意，数字不是等间距的，也不按照数字顺序出现。

处理X轴和分类轴，就像处理Microsoft Excel一样

我们将在两种类型的图表上显示这些数据，第一个图表是XY（散点）图，X作为值轴，第二个图表是折线图，X作为分类轴。

示例代码

from aspose.cells import Workbook
from aspose.cells.charts import ChartType, LegendPositionType
from aspose.cells.drawing import FillType

#  Create an instance of Workbook
workbook = Workbook()
#  Access the first worksheet.
worksheet = workbook.worksheets[0]
#  Put the sample values used in charts
worksheet.cells.get("A2").put_value(1)
worksheet.cells.get("A3").put_value(3)
worksheet.cells.get("A4").put_value(2.5)
worksheet.cells.get("A5").put_value(3.5)
worksheet.cells.get("B1").put_value("Cats")
worksheet.cells.get("C1").put_value("Dogs")
worksheet.cells.get("D1").put_value("Fishes")
worksheet.cells.get("B2").put_value(7)
worksheet.cells.get("B3").put_value(6)
worksheet.cells.get("B4").put_value(5)
worksheet.cells.get("B5").put_value(4)
worksheet.cells.get("C2").put_value(7)
worksheet.cells.get("C3").put_value(5)
worksheet.cells.get("C4").put_value(4)
worksheet.cells.get("C5").put_value(3)
worksheet.cells.get("D2").put_value(8)
worksheet.cells.get("D3").put_value(7)
worksheet.cells.get("D4").put_value(3)
worksheet.cells.get("D5").put_value(2)
# Create Line Chart: X as Category Axis
pieIdx = worksheet.charts.add(ChartType.LINE_WITH_DATA_MARKERS, 6, 15, 20, 21)
#  Retrieve the Chart object
chart = worksheet.charts[pieIdx]
#  Add Series
chart.n_series.add("B2:D5", True)
#  Set the category data
chart.n_series.category_data = "=Sheet1!$A$2:$A$5"
#  Set the first series mame
chart.n_series[0].name = "Cats"
#  Set the second series mame
chart.n_series[1].name = "Dogs"
#  Set the third series mame
chart.n_series[2].name = "Fishes"
#  Set the Legend at the bottom of the chart area
chart.legend.position = LegendPositionType.BOTTOM
#  Fill the PlotArea area with nothing
chart.plot_area.area.fill_format.fill_type = FillType.NONE
#  Create XY (Scatter) Chart: X as Value Axis
pieIdx = worksheet.charts.add(ChartType.SCATTER_CONNECTED_BY_LINES_WITH_DATA_MARKER, 6, 6, 20, 12)
#  Retrieve the Chart object
chart = worksheet.charts[pieIdx]
#  Add Series
chart.n_series.add("B2:D5", True)
#  Set X values for series
chart.n_series[0].x_values = "{1,3,2.5,3.5}"
chart.n_series[1].x_values = "{1,3,2.5,3.5}"
chart.n_series[2].x_values = "{1,3,2.5,3.5}"
#  Set the first series mame
chart.n_series[0].name = "Cats"
#  Set the second series mame
chart.n_series[1].name = "Dogs"
#  Set the third series mame
chart.n_series[2].name = "Fishes"
#  Set the Legend at the bottom of the chart area
chart.legend.position = LegendPositionType.BOTTOM
#  Fill the PlotArea area with nothing
chart.plot_area.area.fill_format.fill_type = FillType.NONE
#  Save the Excel file
workbook.save("XAxis.xlsx")