Establecer fuente de datos para el gráfico
Contents
[
Hide
]
En nuestros temas anteriores, ya proporcionamos muchos ejemplos para demostrar cómo puede configurar una fuente de datos para su gráfico, pero en este tema, proporcionaremos más detalles sobre los tipos de datos que se pueden configurar para un gráfico.
Configuración de los datos del gráfico
Hay dos tipos de datos con los que lidiar al trabajar en gráficos usando Aspose.Cells de la siguiente manera:
- Datos del gráfico.
- Datos de la categoría.
Datos del gráfico
Los datos de gráficos son los datos que utilizamos como fuente de datos para crear nuestros gráficos. Podemos agregar un rango de celdas (que contienen datos del gráfico) llamando alSerieColección objetosAgregarmétodo.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // The path to the documents directory. | |
| string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | |
| // Create directory if it is not already present. | |
| bool IsExists = System.IO.Directory.Exists(dataDir); | |
| if (!IsExists) | |
| System.IO.Directory.CreateDirectory(dataDir); | |
| // Instantiating a Workbook object | |
| Workbook workbook = new Workbook(); | |
| // Adding a new worksheet to the Excel object | |
| int sheetIndex = workbook.Worksheets.Add(); | |
| // Obtaining the reference of the newly added worksheet by passing its sheet index | |
| Worksheet worksheet = workbook.Worksheets[sheetIndex]; | |
| // Adding sample values to cells | |
| worksheet.Cells["A1"].PutValue(50); | |
| worksheet.Cells["A2"].PutValue(100); | |
| worksheet.Cells["A3"].PutValue(170); | |
| worksheet.Cells["A4"].PutValue(300); | |
| worksheet.Cells["B1"].PutValue(160); | |
| worksheet.Cells["B2"].PutValue(32); | |
| worksheet.Cells["B3"].PutValue(50); | |
| worksheet.Cells["B4"].PutValue(40); | |
| // Adding sample values to cells as category data | |
| worksheet.Cells["C1"].PutValue("Q1"); | |
| worksheet.Cells["C2"].PutValue("Q2"); | |
| worksheet.Cells["C3"].PutValue("Y1"); | |
| worksheet.Cells["C4"].PutValue("Y2"); | |
| // Adding a chart to the worksheet | |
| int chartIndex = worksheet.Charts.Add(Aspose.Cells.Charts.ChartType.Column, 5, 0, 15, 5); | |
| // Accessing the instance of the newly added chart | |
| Aspose.Cells.Charts.Chart chart = worksheet.Charts[chartIndex]; | |
| // Adding SeriesCollection (chart data source) to the chart ranging from "A1" cell to "B4" | |
| chart.NSeries.Add("A1:B4", true); | |
| // Saving the Excel file | |
| workbook.Save(dataDir + "output.xls"); |
Datos de categoría
Los datos de categoría se utilizan para el etiquetado de los datos del gráfico y se pueden agregar aSerieColección usando suCategoríaDatospropiedad. A continuación se proporciona un ejemplo completo para demostrar el uso de datos de gráficos y categorías. Después de ejecutar el código de ejemplo anterior, se agregará un gráfico de columnas a la hoja de trabajo como se muestra a continuación.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // The path to the documents directory. | |
| string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | |
| // Create directory if it is not already present. | |
| bool IsExists = System.IO.Directory.Exists(dataDir); | |
| if (!IsExists) | |
| System.IO.Directory.CreateDirectory(dataDir); | |
| // Instantiating a Workbook object | |
| Workbook workbook = new Workbook(); | |
| // Adding a new worksheet to the Excel object | |
| int sheetIndex = workbook.Worksheets.Add(); | |
| // Obtaining the reference of the newly added worksheet by passing its sheet index | |
| Worksheet worksheet = workbook.Worksheets[sheetIndex]; | |
| // Adding sample values to cells | |
| worksheet.Cells["A1"].PutValue(10); | |
| worksheet.Cells["A2"].PutValue(100); | |
| worksheet.Cells["A3"].PutValue(170); | |
| worksheet.Cells["A4"].PutValue(200); | |
| worksheet.Cells["B1"].PutValue(120); | |
| worksheet.Cells["B2"].PutValue(320); | |
| worksheet.Cells["B3"].PutValue(50); | |
| worksheet.Cells["B4"].PutValue(40); | |
| // Adding sample values to cells as category data | |
| worksheet.Cells["C1"].PutValue("Q1"); | |
| worksheet.Cells["C2"].PutValue("Q2"); | |
| worksheet.Cells["C3"].PutValue("Y1"); | |
| worksheet.Cells["C4"].PutValue("Y2"); | |
| // Adding a chart to the worksheet | |
| int chartIndex = worksheet.Charts.Add(Aspose.Cells.Charts.ChartType.Column, 5, 0, 15, 5); | |
| // Accessing the instance of the newly added chart | |
| Aspose.Cells.Charts.Chart chart = worksheet.Charts[chartIndex]; | |
| // Adding SeriesCollection (chart data source) to the chart ranging from "A1" cell to "B4" | |
| chart.NSeries.Add("A1:B4", true); | |
| // Setting the data source for the category data of SeriesCollection | |
| chart.NSeries.CategoryData = "C1:C4"; | |
| // Saving the Excel file | |
| workbook.Save(dataDir + "output.xls"); |