A1VBCode Forums

How to add excel chart at excel last usedrange using vb.net


http://www.a1vbcode.com/vbforums/Topic31947.aspx

By chaw12 - 4/18/2013

Hi,



Currently i have a system that produces an excel report that has a chart on it. i don't have a problem creating the source and adding the chart.

But, I cant insert the chart at the last usedrange of excel.



Can somebody please help me of how I can insert the chart dynamically at every last used range of excel sheet.



VB.net 2010 is my interface.



Thanks in advance!
By aspose_seo - 6/5/2013

Hi chaw12,



Here are some code snippets I found at Aspose.Cells for .NET documentation. I think they will give you some idea about how to add and manipulate charts. Here are some links



http://www.aspose.com/docs/display/cellsnet/How+to+Create+a+Chart

http://www.aspose.com/docs/display/cellsnet/Setting+Charts+Data

http://www.aspose.com/docs/display/cellsnet/Setting+Charts+Appearance



There some other examples as well. I hope they can help to solve your problem.