Configuración de la Apariencia del Gráfico
Configurar la apariencia del gráfico
En Cómo crear un gráfico dimos una breve introducción a los tipos de gráficos y objetos de gráficos ofrecidos por Aspose.Cells, y describimos cómo crear uno. Este artículo discute cómo personalizar la apariencia de los gráficos configurando sus propiedades:
- Configurando el área del gráfico.
- Configurando las líneas del gráfico.
- Aplicando temas.
- Configurando títulos para gráficos y ejes.
- Trabajando con líneas de cuadrícula.
Configurando el área del gráfico
Hay diferentes tipos de áreas en un gráfico y Aspose.Cells proporciona la flexibilidad para modificar la apariencia de cada área. Los desarrolladores pueden aplicar diferentes configuraciones de formato en un área cambiando su color de primer plano, color de fondo y formato de relleno, etc.
En el ejemplo dado a continuación, hemos aplicado diferentes configuraciones de formato en diferentes tipos de áreas de un gráfico. Estas áreas incluyen:
- Área de trazado
- Área del gráfico
- Área de la colección de series
- Área de un solo punto en una colección de series
El siguiente fragmento de código demuestra cómo configurar el área del gráfico.
// 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 Workbook 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(150); | |
worksheet.Cells["B1"].PutValue(60); | |
worksheet.Cells["B2"].PutValue(32); | |
worksheet.Cells["B3"].PutValue(50); | |
// 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 "B3" | |
chart.NSeries.Add("A1:B3", true); | |
// Setting the foreground color of the plot area | |
chart.PlotArea.Area.ForegroundColor = Color.Blue; | |
// Setting the foreground color of the chart area | |
chart.ChartArea.Area.ForegroundColor = Color.Yellow; | |
// Setting the foreground color of the 1st SeriesCollection area | |
chart.NSeries[0].Area.ForegroundColor = Color.Red; | |
// Setting the foreground color of the area of the 1st SeriesCollection point | |
chart.NSeries[0].Points[0].Area.ForegroundColor = Color.Cyan; | |
// Filling the area of the 2nd SeriesCollection with a gradient | |
chart.NSeries[1].Area.FillFormat.SetOneColorGradient(Color.Lime, 1, Aspose.Cells.Drawing.GradientStyleType.Horizontal, 1); | |
// Saving the Excel file | |
workbook.Save(dataDir + "book1.out.xls"); |
Configurando las líneas del gráfico
Los desarrolladores también pueden aplicar diferentes tipos de estilos en las líneas o marcadores de datos de la SeriesCollection. El siguiente fragmento de código demuestra cómo configurar las líneas del gráfico usando la API de Aspose.Cells.
// 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 Workbook 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(150); | |
worksheet.Cells["B1"].PutValue(60); | |
worksheet.Cells["B2"].PutValue(32); | |
worksheet.Cells["B3"].PutValue(50); | |
// 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 "B3" | |
chart.NSeries.Add("A1:B3", true); | |
// Setting the foreground color of the plot area | |
chart.PlotArea.Area.ForegroundColor = Color.Blue; | |
// Setting the foreground color of the chart area | |
chart.ChartArea.Area.ForegroundColor = Color.Yellow; | |
// Setting the foreground color of the 1st SeriesCollection area | |
chart.NSeries[0].Area.ForegroundColor = Color.Red; | |
// Setting the foreground color of the area of the 1st SeriesCollection point | |
chart.NSeries[0].Points[0].Area.ForegroundColor = Color.Cyan; | |
// Filling the area of the 2nd SeriesCollection with a gradient | |
chart.NSeries[1].Area.FillFormat.SetOneColorGradient(Color.Lime, 1, Aspose.Cells.Drawing.GradientStyleType.Horizontal, 1); | |
// Applying a dotted line style on the lines of a SeriesCollection | |
chart.NSeries[0].Border.Style = Aspose.Cells.Drawing.LineType.Dot; | |
// Applying a triangular marker style on the data markers of a SeriesCollection | |
chart.NSeries[0].Marker.MarkerStyle = Aspose.Cells.Charts.ChartMarkerType.Triangle; | |
// Setting the weight of all lines in a SeriesCollection to medium | |
chart.NSeries[1].Border.Weight = Aspose.Cells.Drawing.WeightType.MediumLine; | |
// Saving the Excel file | |
workbook.Save(dataDir + "book1.out.xls"); |
Aplicando temas de Microsoft Excel 2007/2010 a gráficos
Los desarrolladores pueden aplicar diferentes temas/colores de Microsoft Excel a la SeriesCollection u otros objetos de gráfico como se muestra a continuación en el ejemplo.
// 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); | |
// Instantiate the workbook to open the file that contains a chart | |
Workbook workbook = new Workbook(dataDir + "book1.xlsx"); | |
// Get the first worksheet | |
Worksheet worksheet = workbook.Worksheets[1]; | |
// Get the first chart in the sheet | |
Chart chart = worksheet.Charts[0]; | |
// Specify the FilFormat's type to Solid Fill of the first series | |
chart.NSeries[0].Area.FillFormat.FillType = Aspose.Cells.Drawing.FillType.Solid; | |
// Get the CellsColor of SolidFill | |
CellsColor cc = chart.NSeries[0].Area.FillFormat.SolidFill.CellsColor; | |
// Create a theme in Accent style | |
cc.ThemeColor = new ThemeColor(ThemeColorType.Accent6, 0.6); | |
// Apply the them to the series | |
chart.NSeries[0].Area.FillFormat.SolidFill.CellsColor = cc; | |
// Save the Excel file | |
workbook.Save(dataDir + "output.out.xlsx"); |
Configuración de los Títulos de Gráficos o Ejes
Puede utilizar Microsoft Excel para establecer los títulos de un gráfico y sus ejes en un entorno WYSIWYG. Aspose.Cells también permite a los desarrolladores establecer los títulos de un gráfico y sus ejes en tiempo de ejecución. Todos los gráficos y sus ejes contienen una propiedad Title que se puede utilizar para establecer sus títulos como se muestra a continuación en un ejemplo.
El siguiente fragmento de código demuestra cómo establecer títulos en gráficos y ejes.
// 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 Workbook 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(150); | |
worksheet.Cells["B1"].PutValue(60); | |
worksheet.Cells["B2"].PutValue(32); | |
worksheet.Cells["B3"].PutValue(50); | |
// 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 "B3" | |
chart.NSeries.Add("A1:B3", true); | |
// Setting the foreground color of the plot area | |
chart.PlotArea.Area.ForegroundColor = Color.Blue; | |
// Setting the foreground color of the chart area | |
chart.ChartArea.Area.ForegroundColor = Color.Yellow; | |
// Setting the foreground color of the 1st SeriesCollection area | |
chart.NSeries[0].Area.ForegroundColor = Color.Red; | |
// Setting the foreground color of the area of the 1st SeriesCollection point | |
chart.NSeries[0].Points[0].Area.ForegroundColor = Color.Cyan; | |
// Filling the area of the 2nd SeriesCollection with a gradient | |
chart.NSeries[1].Area.FillFormat.SetOneColorGradient(Color.Lime, 1, Aspose.Cells.Drawing.GradientStyleType.Horizontal, 1); | |
// Setting the title of a chart | |
chart.Title.Text = "Title"; | |
// Setting the font color of the chart title to blue | |
chart.Title.Font.Color = Color.Blue; | |
// Setting the title of category axis of the chart | |
chart.CategoryAxis.Title.Text = "Category"; | |
// Setting the title of value axis of the chart | |
chart.ValueAxis.Title.Text = "Value"; | |
// Saving the Excel file | |
workbook.Save(dataDir + "book1.out.xls"); |
Trabajar con líneas de cuadrícula principales
Es posible personalizar el aspecto de las líneas de cuadrícula principales. Ocultar o mostrar las líneas de cuadrícula, o definir su color y otras configuraciones. A continuación, mostramos cómo ocultar las líneas de cuadrícula y cómo cambiar su color.
Ocultar líneas de cuadrícula principales
Los desarrolladores pueden controlar la visibilidad de las líneas de cuadrícula principales estableciendo la propiedad IsVisible del objeto Línea en true o false.
El siguiente fragmento de código demuestra cómo ocultar las líneas de cuadrícula principales. Después de ocultar las líneas de cuadrícula principales, se agregará un gráfico de columnas a la hoja de cálculo sin líneas de cuadrícula.
// 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 Workbook 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(150); | |
worksheet.Cells["B1"].PutValue(60); | |
worksheet.Cells["B2"].PutValue(32); | |
worksheet.Cells["B3"].PutValue(50); | |
// 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 "B3" | |
chart.NSeries.Add("A1:B3", true); | |
// Setting the foreground color of the plot area | |
chart.PlotArea.Area.ForegroundColor = Color.Blue; | |
// Setting the foreground color of the chart area | |
chart.ChartArea.Area.ForegroundColor = Color.Yellow; | |
// Setting the foreground color of the 1st SeriesCollection area | |
chart.NSeries[0].Area.ForegroundColor = Color.Red; | |
// Setting the foreground color of the area of the 1st SeriesCollection point | |
chart.NSeries[0].Points[0].Area.ForegroundColor = Color.Cyan; | |
// Filling the area of the 2nd SeriesCollection with a gradient | |
chart.NSeries[1].Area.FillFormat.SetOneColorGradient(Color.Lime, 1, Aspose.Cells.Drawing.GradientStyleType.Horizontal, 1); | |
// Hiding the major gridlines of Category Axis | |
chart.CategoryAxis.MajorGridLines.IsVisible = false; | |
// Hiding the major gridlines of Value Axis | |
chart.ValueAxis.MajorGridLines.IsVisible = false; | |
// Saving the Excel file | |
workbook.Save(dataDir + "book1.out.xls"); |
Cambiando la configuración de las líneas de cuadrícula principales
Los desarrolladores no solo pueden controlar la visibilidad de las líneas de cuadrícula principales, sino también otras propiedades, incluido su color, etc.
El siguiente fragmento de código demuestra cómo cambiar el color de las líneas de cuadrícula principales. Después de establecer el color de las líneas de cuadrícula principales, se agregará un gráfico de columnas a la hoja de cálculo con líneas de cuadrícula modificadas.
// 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 Workbook 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(150); | |
worksheet.Cells["B1"].PutValue(60); | |
worksheet.Cells["B2"].PutValue(32); | |
worksheet.Cells["B3"].PutValue(50); | |
// 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 "B3" | |
chart.NSeries.Add("A1:B3", true); | |
// Setting the foreground color of the plot area | |
chart.PlotArea.Area.ForegroundColor = Color.Blue; | |
// Setting the foreground color of the chart area | |
chart.ChartArea.Area.ForegroundColor = Color.Yellow; | |
// Setting the foreground color of the 1st SeriesCollection area | |
chart.NSeries[0].Area.ForegroundColor = Color.Red; | |
// Setting the foreground color of the area of the 1st SeriesCollection point | |
chart.NSeries[0].Points[0].Area.ForegroundColor = Color.Cyan; | |
// Filling the area of the 2nd SeriesCollection with a gradient | |
chart.NSeries[1].Area.FillFormat.SetOneColorGradient(Color.Lime, 1, Aspose.Cells.Drawing.GradientStyleType.Horizontal, 1); | |
// Setting the color of Category Axis' major gridlines to silver | |
chart.CategoryAxis.MajorGridLines.Color = Color.Silver; | |
// Setting the color of Value Axis' major gridlines to red | |
chart.ValueAxis.MajorGridLines.Color = Color.Red; | |
// Saving the Excel file | |
workbook.Save(dataDir + "book1.out.xls"); |