Insertar Gráfico de Chispa
Contents
[
Hide
]
Insertar un gráfico de chispa
Un gráfico de chispa es un gráfico pequeño en una celda de la hoja de cálculo que proporciona una representación visual de datos. Utilice gráficos de chispa para mostrar tendencias en una serie de valores, como aumentos o disminuciones estacionales, ciclos económicos o resaltar valores máximos y mínimos. Coloque un gráfico de chispa cerca de sus datos para lograr un mayor impacto. Hay tres tipos de Gráficos de Chispa: Línea, Columna y Apilado.
Es sencillo crear un gráfico de chispa con Aspose.Cells con los siguientes ejemplos de códigos:
This file contains 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); | |
// Instantiating a Workbook object | |
Workbook book = new Workbook(); | |
Worksheet sheet = book.Worksheets[0]; | |
sheet.Cells["A1"].PutValue(5); | |
sheet.Cells["B1"].PutValue(2); | |
sheet.Cells["C1"].PutValue(1); | |
sheet.Cells["D1"].PutValue(3); | |
// Define the CellArea | |
CellArea ca = new CellArea(); | |
ca.StartColumn = 4; | |
ca.EndColumn = 4; | |
ca.StartRow = 0; | |
ca.EndRow = 0; | |
int idx = sheet.SparklineGroups.Add(Aspose.Cells.Charts.SparklineType.Line, sheet.Name + "!A1:D1", false, ca); | |
SparklineGroup group = sheet.SparklineGroups[idx]; | |
group.Sparklines.Add(sheet.Name + "!A1:D1", 0, 4); | |
#region Customize Sparklines | |
// Create CellsColor | |
CellsColor clr = book.CreateCellsColor(); | |
clr.Color = Color.Orange; | |
group.SeriesColor = clr; | |
// set the high points are colored green and the low points are colored red | |
group.ShowHighPoint = true; | |
group.ShowLowPoint = true; | |
group.HighPointColor.Color = Color.Green; | |
group.LowPointColor.Color = Color.Red; | |
// set line weight | |
group.LineWeight = 1.0; | |
// you also can choose a nice visual style | |
// group.PresetStyle = SparklinePresetStyleType.Style10; | |
#endregion Customize Sparklines | |
// Saving the Excel file | |
book.Save(dataDir + "output.xlsx"); |