Modify a existing chart at runtime

Aspose.Cells Product Family
1

I have a chart that I have created in an excel file. I open the excel file and want to change the charts title.

I am using this.

Dim oChart As Aspose.Cells.Chart = workbook.Worksheets(1).DesignCharts(0)
oChart.Title.Text = Me.CreditUnionName & " - Test"
oChart.CategoryAxis.Title.Text = "TESTER"

The title of the chart does not change to - Test. What am I doing wrong?

2

Hi,

Thanks for considering Aspose.

Well, yes, thanks for pointing it out. Although the worksheet.DesignCharts.Count is fine but there seams to some sort of problem while retrieving and changing it. We will figure out and resolve the issue soon.

Best Regards

3

Currently Aspose.Cells doesn't hand charts in template file well. However we are working to enhance it. Hopefully in March 2007 we will provide the feature to totally manipulate all properties for charts in template files.