图表中的数据格式

在我们之前的主题中，我们已经提供了许多示例来演示如何为图表设置数据源，但在本主题中，我们将提供有关可以为图表设置的数据类型的更多详细信息。

设置图表数据

在使用 Aspose.Cells 处理图表时，有两种类型的数据需要处理，如下所示：

• 图表数据.
• 类别数据.

图表数据

图表数据是我们用作构建图表的数据源的数据。我们可以通过调用系列合集对象的[添加](https://reference.aspose.com/cells/java/com.aspose.cells/seriescollection#add(java.lang.Object)） 方法。

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
// The path to the documents directory.
String dataDir = Utils.getSharedDataDir(SettingChartsData.class) + "charts/";

// Instantiating a Workbook object
Workbook workbook = new Workbook();
WorksheetCollection worksheets = workbook.getWorksheets();

// Obtaining the reference of the first worksheet
Worksheet worksheet = worksheets.get(0);
Cells cells = worksheet.getCells();

// Adding a sample value to "A1" cell
cells.get("A1").setValue(50);

// Adding a sample value to "A2" cell
cells.get("A2").setValue(100);

// Adding a sample value to "A3" cell
cells.get("A3").setValue(150);

// Adding a sample value to "A4" cell
cells.get("A4").setValue(200);

// Adding a sample value to "B1" cell
cells.get("B1").setValue(60);

// Adding a sample value to "B2" cell
cells.get("B2").setValue(32);

// Adding a sample value to "B3" cell
cells.get("B3").setValue(50);

// Adding a sample value to "B4" cell
cells.get("B4").setValue(40);

// Adding a sample value to "C1" cell as category data
cells.get("C1").setValue("Q1");

// Adding a sample value to "C2" cell as category data
cells.get("C2").setValue("Q2");

// Adding a sample value to "C3" cell as category data
cells.get("C3").setValue("Y1");

// Adding a sample value to "C4" cell as category data
cells.get("C4").setValue("Y2");

// Adding a chart to the worksheet
ChartCollection charts = worksheet.getCharts();

// Accessing the instance of the newly added chart
int chartIndex = charts.add(ChartType.COLUMN, 5, 0, 15, 5);
Chart chart = charts.get(chartIndex);

// Adding NSeries (chart data source) to the chart ranging from "A1"
// cell to "B4"
SeriesCollection nSeries = chart.getNSeries();
nSeries.add("A1:B4", true);

// Setting the data source for the category data of NSeries
nSeries.setCategoryData("C1:C4");

workbook.save(dataDir + "SettingChartsData_out.xls");

// Print message
System.out.println("Workbook with chart is created successfully.");

类别数据

分类数据用于图表数据的标注，可以添加到系列合集通过使用其设置类别数据方法。

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
// The path to the documents directory.
String dataDir = Utils.getSharedDataDir(SettingCategoryData.class) + "charts/";

// Instantiating a Workbook object
Workbook workbook = new Workbook();
WorksheetCollection worksheets = workbook.getWorksheets();

// Obtaining the reference of the first worksheet
Worksheet worksheet = worksheets.get(0);
Cells cells = worksheet.getCells();

// Adding a sample value to "A1" cell
cells.get("A1").setValue(50);

// Adding a sample value to "A2" cell
cells.get("A2").setValue(100);

// Adding a sample value to "A3" cell
cells.get("A3").setValue(150);

// Adding a sample value to "A4" cell
cells.get("A4").setValue(200);

// Adding a sample value to "B1" cell
cells.get("B1").setValue(60);

// Adding a sample value to "B2" cell
cells.get("B2").setValue(32);

// Adding a sample value to "B3" cell
cells.get("B3").setValue(50);

// Adding a sample value to "B4" cell
cells.get("B4").setValue(40);

// Adding a sample value to "C1" cell as category data
cells.get("C1").setValue("Q1");

// Adding a sample value to "C2" cell as category data
cells.get("C2").setValue("Q2");

// Adding a sample value to "C3" cell as category data
cells.get("C3").setValue("Y1");

// Adding a sample value to "C4" cell as category data
cells.get("C4").setValue("Y2");

// Adding a chart to the worksheet
ChartCollection charts = worksheet.getCharts();

// Accessing the instance of the newly added chart
int chartIndex = charts.add(ChartType.COLUMN, 5, 0, 15, 5);
Chart chart = charts.get(chartIndex);

// Adding NSeries (chart data source) to the chart ranging from "A1"
// cell to "B4"
SeriesCollection nSeries = chart.getNSeries();
nSeries.add("A1:B4", true);

// Setting the data source for the category data of NSeries
nSeries.setCategoryData("C1:C4");

workbook.save(dataDir + "SettingCategoryData_out.xls");

// Print message
System.out.println("Workbook with chart is created successfully.");

包含图表和类别数据的柱形图

推进主题

• 创建动态图表
• 使用 Chart.setChartDataRange 方法设置图表的简便方法
• 查找图表系列中点的 X 和 Y 值类型
• 设置图表系列的值格式代码