How to create gantt chart from scratch

abhisheksands · December 6, 2013, 1:46am

can you tell me how to create gantt chart from scratch with the help of aspose api?
can i bind data from sql to show the gantt chart?

This message was posted using Email2Forum by Tahir Manzoor.

amjad.sahi · December 6, 2013, 2:30am

Hi,

MS Excel (2003, 2007/2010) does not offer build-in Gantt chart type. I think you may use Stacked bar chart for your purpose to create your desired Gantt chart in MS Excel file format, see the topic for your reference:

http://www.excel-easy.com/examples/gantt-chart.html

Please see the demo on how to create Stacked bar chart for your reference, you may use Aspose.Cells APIs to create the above mentioned chart (in the article) accordingly for your needs.

Also, you may render the char to image if you want, see the document for your reference:

And, Aspose.Cells does not support to bind data from SQL Server db to chart in Excel, you have to first import data from database to fill data into worksheet cells and then create the chart.

Thank you.