Форматирование данных в диаграммах

Установка данных графика

При работе с графиками с использованием Aspose.Cells есть два типа данных, с которыми нужно работать, следующие:

Данные графика

Данные диаграммы - это данные, которые мы используем в качестве источника данных для создания графиков. Мы можем добавить диапазон ячеек (содержащий данные диаграммы), вызвав метод Add объекта SeriesCollection.

// 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.");

Данные категорий

Данные категории используются для маркировки данных диаграммы и могут быть добавлены к SeriesCollection с помощью его метода setCategoryData.

// 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.");

Столбчатая диаграмма с данными диаграммы и категории

todo:image_alt_text

Продвинутые темы