Formatage des données dans les graphiques
Définition des données du graphique
Il existe deux types de données à manipuler lors de l’utilisation de graphiques avec Aspose.Cells, comme suit :
Données du graphique
Les données de graphique sont les données que nous utilisons comme source de données pour construire nos graphiques. Nous pouvons ajouter une plage de cellules (contenant des données de graphique) en appelant la méthode Add de l’objet 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."); |
Données de catégorie
Les données de catégorie sont utilisées pour l’étiquetage des données de graphique et peuvent être ajoutées à SeriesCollection en utilisant sa méthode 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."); |
Diagramme en colonnes avec données de graphique & de catégorie