Updating an Existing Chart in Python
Contents
[
Hide
]
Aspose.Slides - Updating an Existing Chart
To Update an Existing Chart Aspose.Slides Java for Python. Here you can see example code.
Python Code
# Instantiate Presentation class that represents the presentation file
pres = self.Presentation(self.dataDir + "AsposeChart.pptx")
\# Access first slide
sld = pres.getSlides().get_Item(0)
\# Add chart with default data
chart = sld.getShapes().get_Item(0)
\# Setting the index of chart data sheet
defaultWorksheetIndex = 0
\# Getting the chart data worksheet
fact = chart.getChartData().getChartDataWorkbook()
\# Changing chart Category Name
fact.getCell(defaultWorksheetIndex, 1, 0, "Modified Category 1")
fact.getCell(defaultWorksheetIndex, 2, 0, "Modified Category 2")
\# Take first chart series
series = chart.getChartData().getSeries().get_Item(0)
\# Now updating series data
fact.getCell(defaultWorksheetIndex, 0, 1, "New_Series1") # modifying series name
series.getDataPoints().get_Item(0).getValue().setData(90)
series.getDataPoints().get_Item(1).getValue().setData(123)
series.getDataPoints().get_Item(2).getValue().setData(44)
\# Take Second chart series
series = chart.getChartData().getSeries().get_Item(1)
\# Now updating series data
fact.getCell(defaultWorksheetIndex, 0, 2, "New_Series2") #modifying series name
series.getDataPoints().get_Item(0).getValue().setData(23)
series.getDataPoints().get_Item(1).getValue().setData(67)
series.getDataPoints().get_Item(2).getValue().setData(99)
\# Now, Adding a self.series
chart.getChartData().getSeries().add(fact.getCell(defaultWorksheetIndex, 0, 3, "Series 3"), chart.getType())
\# Take 3rd chart series
series = chart.getChartData().getSeries().get_Item(2)
\# Now populating series data
series.getDataPoints().addDataPointForBarSeries(fact.getCell(defaultWorksheetIndex, 1, 3, 20))
series.getDataPoints().addDataPointForBarSeries(fact.getCell(defaultWorksheetIndex, 2, 3, 50))
series.getDataPoints().addDataPointForBarSeries(fact.getCell(defaultWorksheetIndex, 3, 3, 30))
chartType=self.ChartType
chart.setType(chartType.ClusteredCylinder)
\# Saving the presentation to HTML format
save_format = self.SaveFormat
pres.save(self.dataDir + "AsposeChartModified.pptx", save_format.Pptx)
print "Updated chart, please check the output file."
Download Running Code
Download running code from any of the below mentioned social coding sites: