Grafik Görünümünü Ayarlama

Grafik Görünümünü Ayarlama

Grafik Oluşturma Nasıl Yapılır başlığında, Aspose.Cells for Python via .NET tarafından sunulan grafik türleri ve grafik nesnelerine kısa bir giriş yapmış ve nasıl oluşturulacağını anlatmıştık. Bu makale, grafiklerin görünümünü aşağıdaki gibi özelleştirmeye odaklanmıştır:

• Grafik alanını ayarlama.
• Grafik çizgilerini ayarlama.
• Temalar uygulama.
• Grafiklere ve eksenlere başlıklar eklemek.
• Izgaralarla çalışma.

Grafik Alanını Ayarlama

Bir grafikte farklı alanlar olabilir ve Aspose.Cells for Python via .NET, her alanın görünümünü değiştirme esnekliği sağlar. Geliştiriciler, alanın ön plan rengini, arka plan rengini ve doldurma ayarlarını değiştirerek farklı biçimlendirme uygulayabilirler.

Aşağıdaki örnekte, bir grafikte farklı türde alanlara farklı biçimlendirme ayarları uyguladık. Bu alanlar şunları içerir:

• Plot alanı
• Grafik alanı
• Seri koleksiyonu alanı
• Bir Seri Koleksiyonu içindeki tek bir noktanın alanı

Aşağıdaki kod parçası, grafik alanını nasıl ayarlayacağınızı göstermektedir.

from aspose.cells import Workbook
from aspose.cells.charts import ChartType
from aspose.cells.drawing import GradientStyleType
from aspose.pydrawing import Color
from os import os, path

#  For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
#  The path to the documents directory.
dataDir = RunExamples.GetDataDir(".")
#  Create directory if it is not already present.
IsExists = path.isdir(dataDir)
if notIsExists:
    os.makedirs(dataDir)
#  Instantiating a Workbook object
workbook = Workbook()
#  Adding a new worksheet to the Workbook object
sheetIndex = workbook.worksheets.add()
#  Obtaining the reference of the newly added worksheet by passing its sheet index
worksheet = workbook.worksheets[sheetIndex]
#  Adding sample values to cells
worksheet.cells.get("A1").put_value(50)
worksheet.cells.get("A2").put_value(100)
worksheet.cells.get("A3").put_value(150)
worksheet.cells.get("B1").put_value(60)
worksheet.cells.get("B2").put_value(32)
worksheet.cells.get("B3").put_value(50)
#  Adding a chart to the worksheet
chartIndex = worksheet.charts.add(ChartType.COLUMN, 5, 0, 15, 5)
#  Accessing the instance of the newly added chart
chart = worksheet.charts[chartIndex]
#  Adding SeriesCollection (chart data source) to the chart ranging from "A1" cell to "B3"
chart.n_series.add("A1:B3", True)
#  Setting the foreground color of the plot area
chart.plot_area.area.foreground_color = Color.blue
#  Setting the foreground color of the chart area
chart.chart_area.area.foreground_color = Color.yellow
#  Setting the foreground color of the 1st SeriesCollection area
chart.n_series[0].area.foreground_color = Color.red
#  Setting the foreground color of the area of the 1st SeriesCollection point
chart.n_series[0].points[0].area.foreground_color = Color.cyan
#  Filling the area of the 2nd SeriesCollection with a gradient
chart.n_series[1].area.fill_format.set_one_color_gradient(Color.lime, 1, GradientStyleType.HORIZONTAL, 1)
#  Saving the Excel file
workbook.save(dataDir + "book1.out.xls")

Grafik Çizgilerini Ayarlama

Geliştiriciler ayrıca SeriesCollection üzerindeki çizgi veya veri işaretçilerine farklı stiller uygulayabilirler. Aşağıdaki kod örneği, Aspose.Cells for Python via .NET API kullanarak grafik çizgilerini nasıl ayarlayacağınızı gösterir.

from aspose.cells import Workbook
from aspose.cells.charts import ChartMarkerType, ChartType
from aspose.cells.drawing import GradientStyleType, LineType, WeightType
from aspose.pydrawing import Color
from os import os, path

#  For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
#  The path to the documents directory.
dataDir = RunExamples.GetDataDir(".")
#  Create directory if it is not already present.
IsExists = path.isdir(dataDir)
if notIsExists:
    os.makedirs(dataDir)
#  Instantiating a Workbook object
workbook = Workbook()
#  Adding a new worksheet to the Workbook object
sheetIndex = workbook.worksheets.add()
#  Obtaining the reference of the newly added worksheet by passing its sheet index
worksheet = workbook.worksheets[sheetIndex]
#  Adding sample values to cells
worksheet.cells.get("A1").put_value(50)
worksheet.cells.get("A2").put_value(100)
worksheet.cells.get("A3").put_value(150)
worksheet.cells.get("B1").put_value(60)
worksheet.cells.get("B2").put_value(32)
worksheet.cells.get("B3").put_value(50)
#  Adding a chart to the worksheet
chartIndex = worksheet.charts.add(ChartType.COLUMN, 5, 0, 15, 5)
#  Accessing the instance of the newly added chart
chart = worksheet.charts[chartIndex]
#  Adding SeriesCollection (chart data source) to the chart ranging from "A1" cell to "B3"
chart.n_series.add("A1:B3", True)
#  Setting the foreground color of the plot area
chart.plot_area.area.foreground_color = Color.blue
#  Setting the foreground color of the chart area
chart.chart_area.area.foreground_color = Color.yellow
#  Setting the foreground color of the 1st SeriesCollection area
chart.n_series[0].area.foreground_color = Color.red
#  Setting the foreground color of the area of the 1st SeriesCollection point
chart.n_series[0].points[0].area.foreground_color = Color.cyan
#  Filling the area of the 2nd SeriesCollection with a gradient
chart.n_series[1].area.fill_format.set_one_color_gradient(Color.lime, 1, GradientStyleType.HORIZONTAL, 1)
#  Applying a dotted line style on the lines of a SeriesCollection
chart.n_series[0].border.style = LineType.DOT
#  Applying a triangular marker style on the data markers of a SeriesCollection
chart.n_series[0].marker.marker_style = ChartMarkerType.TRIANGLE
#  Setting the weight of all lines in a SeriesCollection to medium
chart.n_series[1].border.weight = WeightType.MEDIUM_LINE
#  Saving the Excel file
workbook.save(dataDir + "book1.out.xls")

Microsoft Excel 2007/2010 Temalarını Grafiklere Uygulama

Geliştiriciler, aşağıdaki örnekte gösterildiği gibi SeriesCollection veya diğer grafik nesnelerine farklı Microsoft Excel temaları/rengleri uygulayabilirler.

from aspose.cells import ThemeColor, ThemeColorType, Workbook
from aspose.cells.drawing import FillType

#  For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
#  The path to the documents directory.
dataDir = RunExamples.GetDataDir(".")
#  Instantiate the workbook to open the file that contains a chart
workbook = Workbook(dataDir + "book1.xlsx")
#  Get the first worksheet
worksheet = workbook.worksheets[1]
#  Get the first chart in the sheet
chart = worksheet.charts[0]
#  Specify the FilFormat's type to Solid Fill of the first series
chart.n_series[0].area.fill_format.fill_type = FillType.SOLID
#  Get the CellsColor of SolidFill
cc = chart.n_series[0].area.fill_format.solid_fill.cells_color
#  Create a theme in Accent style
cc.theme_color = ThemeColor(ThemeColorType.ACCENT6, 0.6)
#  Apply the them to the series
chart.n_series[0].area.fill_format.solid_fill.cells_color = cc
#  Save the Excel file
workbook.save(dataDir + "output.out.xlsx")

Grafiğin veya Eksenlerin Başlıklarını Ayarlama

Microsoft Excel kullanarak bir grafik ve eksenlerin başlıklarını WYSIWYG ortamında ayarlayabilirsiniz. Aspose.Cells for Python via .NET, geliştirilicilere grafik ve eksenlerin başlıklarını çalışma zamanında ayarlama imkanı da sağlar. Tüm grafikler ve eksenleri, aşağıdaki örnekte gösterildiği gibi, Chart.title özelliğine sahiptir.

Aşağıdaki kod parçacığı, grafikler ve eksenlerin başlıklarını nasıl ayarlayacağını göstermektedir.

from aspose.cells import Workbook
from aspose.cells.charts import ChartType
from aspose.cells.drawing import GradientStyleType
from aspose.pydrawing import Color
from os import os, path

#  For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
#  The path to the documents directory.
dataDir = RunExamples.GetDataDir(".")
#  Create directory if it is not already present.
IsExists = path.isdir(dataDir)
if notIsExists:
    os.makedirs(dataDir)
#  Instantiating a Workbook object
workbook = Workbook()
#  Adding a new worksheet to the Workbook object
sheetIndex = workbook.worksheets.add()
#  Obtaining the reference of the newly added worksheet by passing its sheet index
worksheet = workbook.worksheets[sheetIndex]
#  Adding sample values to cells
worksheet.cells.get("A1").put_value(50)
worksheet.cells.get("A2").put_value(100)
worksheet.cells.get("A3").put_value(150)
worksheet.cells.get("B1").put_value(60)
worksheet.cells.get("B2").put_value(32)
worksheet.cells.get("B3").put_value(50)
#  Adding a chart to the worksheet
chartIndex = worksheet.charts.add(ChartType.COLUMN, 5, 0, 15, 5)
#  Accessing the instance of the newly added chart
chart = worksheet.charts[chartIndex]
#  Adding SeriesCollection (chart data source) to the chart ranging from "A1" cell to "B3"
chart.n_series.add("A1:B3", True)
#  Setting the foreground color of the plot area
chart.plot_area.area.foreground_color = Color.blue
#  Setting the foreground color of the chart area
chart.chart_area.area.foreground_color = Color.yellow
#  Setting the foreground color of the 1st SeriesCollection area
chart.n_series[0].area.foreground_color = Color.red
#  Setting the foreground color of the area of the 1st SeriesCollection point
chart.n_series[0].points[0].area.foreground_color = Color.cyan
#  Filling the area of the 2nd SeriesCollection with a gradient
chart.n_series[1].area.fill_format.set_one_color_gradient(Color.lime, 1, 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.category_axis.title.text = "Category"
#  Setting the title of value axis of the chart
chart.value_axis.title.text = "Value"
#  Saving the Excel file
workbook.save(dataDir + "book1.out.xls")

Büyük Izgaralarla Çalışma

Büyük ızgaraların görünümünü özelleştirmek mümkündür. Izgaraları gizlemek veya göstermek, renk ve diğer ayarları tanımlamak vb. aşağıda, ızgaraların nasıl gizleneceğini ve renginin nasıl değiştirileceğini gösteriyoruz.

Büyük Izgaraları Gizleme

Geliştiriciler, Line nesnesinin is_visible özelliğini true veya false yaparak ana ızgara çizgilerinin görünürlüğünü kontrol edebilirler.

Aşağıdaki kod parçası, büyük ızgaraları nasıl gizleyeceğinizi göstermektedir. Büyük ızgaraları gizledikten sonra, bir sütun grafiği çalışma sayfasına eklenecek ve ızgaraları olmayacaktır.

from aspose.cells import Workbook
from aspose.cells.charts import ChartType
from aspose.cells.drawing import GradientStyleType
from aspose.pydrawing import Color
from os import os, path

#  For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
#  The path to the documents directory.
dataDir = RunExamples.GetDataDir(".")
#  Create directory if it is not already present.
IsExists = path.isdir(dataDir)
if notIsExists:
    os.makedirs(dataDir)
#  Instantiating a Workbook object
workbook = Workbook()
#  Adding a new worksheet to the Workbook object
sheetIndex = workbook.worksheets.add()
#  Obtaining the reference of the newly added worksheet by passing its sheet index
worksheet = workbook.worksheets[sheetIndex]
#  Adding sample values to cells
worksheet.cells.get("A1").put_value(50)
worksheet.cells.get("A2").put_value(100)
worksheet.cells.get("A3").put_value(150)
worksheet.cells.get("B1").put_value(60)
worksheet.cells.get("B2").put_value(32)
worksheet.cells.get("B3").put_value(50)
#  Adding a chart to the worksheet
chartIndex = worksheet.charts.add(ChartType.COLUMN, 5, 0, 15, 5)
#  Accessing the instance of the newly added chart
chart = worksheet.charts[chartIndex]
#  Adding SeriesCollection (chart data source) to the chart ranging from "A1" cell to "B3"
chart.n_series.add("A1:B3", True)
#  Setting the foreground color of the plot area
chart.plot_area.area.foreground_color = Color.blue
#  Setting the foreground color of the chart area
chart.chart_area.area.foreground_color = Color.yellow
#  Setting the foreground color of the 1st SeriesCollection area
chart.n_series[0].area.foreground_color = Color.red
#  Setting the foreground color of the area of the 1st SeriesCollection point
chart.n_series[0].points[0].area.foreground_color = Color.cyan
#  Filling the area of the 2nd SeriesCollection with a gradient
chart.n_series[1].area.fill_format.set_one_color_gradient(Color.lime, 1, GradientStyleType.HORIZONTAL, 1)
#  Hiding the major gridlines of Category Axis
chart.category_axis.major_grid_lines.is_visible = False
#  Hiding the major gridlines of Value Axis
chart.value_axis.major_grid_lines.is_visible = False
#  Saving the Excel file
workbook.save(dataDir + "book1.out.xls")

Büyük Izgaraların Ayarlarını Değiştirme

Geliştiriciler, yalnızca büyük ızgaraların görünürlüğünü değil, aynı zamanda rengi gibi diğer özelliklerini de kontrol edebilirler.

Aşağıdaki kod parçası, büyük ızgaraların rengini nasıl değiştireceğinizi göstermektedir. Büyük ızgaraların rengini ayarladıktan sonra, bir sütun grafiği çalışma sayfasına değiştirilmiş ızgaralarla eklenecektir.

from aspose.cells import Workbook
from aspose.cells.charts import ChartType
from aspose.cells.drawing import GradientStyleType
from aspose.pydrawing import Color
from os import os, path

#  For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
#  The path to the documents directory.
dataDir = RunExamples.GetDataDir(".")
#  Create directory if it is not already present.
IsExists = path.isdir(dataDir)
if notIsExists:
    os.makedirs(dataDir)
#  Instantiating a Workbook object
workbook = Workbook()
#  Adding a new worksheet to the Workbook object
sheetIndex = workbook.worksheets.add()
#  Obtaining the reference of the newly added worksheet by passing its sheet index
worksheet = workbook.worksheets[sheetIndex]
#  Adding sample values to cells
worksheet.cells.get("A1").put_value(50)
worksheet.cells.get("A2").put_value(100)
worksheet.cells.get("A3").put_value(150)
worksheet.cells.get("B1").put_value(60)
worksheet.cells.get("B2").put_value(32)
worksheet.cells.get("B3").put_value(50)
#  Adding a chart to the worksheet
chartIndex = worksheet.charts.add(ChartType.COLUMN, 5, 0, 15, 5)
#  Accessing the instance of the newly added chart
chart = worksheet.charts[chartIndex]
#  Adding SeriesCollection (chart data source) to the chart ranging from "A1" cell to "B3"
chart.n_series.add("A1:B3", True)
#  Setting the foreground color of the plot area
chart.plot_area.area.foreground_color = Color.blue
#  Setting the foreground color of the chart area
chart.chart_area.area.foreground_color = Color.yellow
#  Setting the foreground color of the 1st SeriesCollection area
chart.n_series[0].area.foreground_color = Color.red
#  Setting the foreground color of the area of the 1st SeriesCollection point
chart.n_series[0].points[0].area.foreground_color = Color.cyan
#  Filling the area of the 2nd SeriesCollection with a gradient
chart.n_series[1].area.fill_format.set_one_color_gradient(Color.lime, 1, GradientStyleType.HORIZONTAL, 1)
#  Setting the color of Category Axis' major gridlines to silver
chart.category_axis.major_grid_lines.color = Color.silver
#  Setting the color of Value Axis' major gridlines to red
chart.value_axis.major_grid_lines.color = Color.red
#  Saving the Excel file
workbook.save(dataDir + "book1.out.xls")

Gelişmiş Konular

• Grafik Serisinin Değer Biçim Kodunu Ayarlayın
• Grafikte Arka Plan Doldurma Olarak Resim Ayarlama