Dataformatering i diagram

våra tidigare ämnen har vi redan gett många exempel för att visa hur du kan ställa in en datakälla för ditt diagram, men i det här ämnet kommer vi att ge mer information om vilka typer av data som kan ställas in för ett diagram.

Ställa in diagramdata

Det finns två typer av data att hantera när du arbetar med diagram med Aspose.Cells enligt följande:

• Diagramdata.
• Kategoridata.

Diagramdata

Diagramdata är den data som vi använder som datakälla för att bygga våra diagram. Vi kan lägga till ett intervall av cellerna (som innehåller diagramdata) genom att anropaSeriekollektion föremålLägg till metod.

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

Kategoridata

Kategoridata används för märkning av sjökortsdata och kan läggas tillSeriekollektion genom att använda desssetCategoryDatametod.

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

Kolumndiagram med diagram & kategoridata

Förhandsämnen

• Skapa dynamiska diagram
• Enkelt sätt för diagraminställning med metoden Chart.setChartDataRange
• Hitta typ av X- och Y-värden för poäng i diagramserier
• Ställ in värdeformatets kod för diagramserien