Updating an Existing Chart in Ruby

Aspose.Slides - Updating an Existing Chart

To Update an Existing Chart using Aspose.Slides Java for Ruby, simply invoke ExistingChart module. Here you can see example code.

Ruby Code

 data_dir = File.dirname(File.dirname(File.dirname(File.dirname(__FILE__)))) + '/data/'



\# Instantiate Presentation class that represents the presentation file

pres = Rjb::import('com.aspose.slides.Presentation').new(data_dir+ "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 new 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))

chart.setType(Rjb::import('com.aspose.slides.ChartType').ClusteredCylinder)


\# Saving the presentation to HTML format

save_format = Rjb::import('com.aspose.slides.SaveFormat')

pres.save(data_dir + "AsposeChartModified.pptx", save_format.Pptx)

puts "Updated chart, please check the output file."

Download Running Code

Download Updating an Existing Chart (Aspose.Slides) from any of the below mentioned social coding sites:

• GitHub