How to create a Gantt chart like sprint report with shapes in presentation?

In PowerPoint presentation, you can create a Gantt chart like sprint report for the data in excel file or from database. The Essential Presentation and Essential XlsIO libraries can be used to achieve this.

Steps to create a Gantt chart like sprint report:

1. Divide the PowerPoint slide’s width by the number of sprints involved in the sprint report.
2. Divide each sprint space with the number of days involved in the sprint.
3. Get the start and end dates of a task
4. Now you can draw a rectangle shape for each task by calculating the bounds from its start and end dates.

The above steps can produce the result as shown below.

You can find the sample here.

Note

The below links demonstrates importing data from a database to an excel file using Essential XlsIO library.

KB link: https://help.syncfusion.com/file-formats/xlsio/working-with-data#import-data-from-datatable

Sample: http://mvc.syncfusion.com/demos/web/xlsio/externalconnection