Formateo de datos en gráficos

Establecer Datos del Gráfico

Hay dos tipos de datos con los que trabajar al utilizar gráficos con Aspose.Cells como se muestra a continuación:

Datos del Gráfico

Los datos del gráfico son aquellos datos que utilizamos como origen de datos para construir nuestros gráficos. Podemos agregar un rango de celdas (que contienen datos del gráfico) llamando al método Add del objeto 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.");

Datos de Categoría

Los datos de categoría se utilizan para etiquetar los datos del gráfico y se pueden agregar a SeriesCollection mediante su método 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.");

Gráfico de columnas con datos de gráfico y categoría

todo:image_alt_text

Temas avanzados