How to create Gantt chart

What is Gantt chart

A Gantt chart helps you schedule your project tasks and then helps you track your progress.

Add Gantt chart in Excel

Need to show status for a simple project schedule with a Gantt chart? Though Excel doesn’t have a predefined Gantt chart type, you can simulate one by customizing a stacked bar chart to show the start and finish dates of tasks, like this:

How to create

• Select the data you want to chart. In our example, that’s B1:B7,and then Insert Stacked Bar chart.

• Selett the chart,Select Data->Add,set the Series name and Series values as following

• Select the chart,Edit the Horizontal(Category) Axis Labels

• Format Axis the Y Axis,select Categories in reverse order
• Seletct the Blue Series and set the Fill->NO Fill
• Format Axis the X Axis,set the Mininum and Maxinum(1/5/2019:43470,1/30/2019:43494)

• Add Data lebles for the chart Now you get a gantt chart.

Add Gantt chart in Aspose.Cells

The following sample code creates a Gantt chart by open a sample file

// Create an instance of Workbook
Workbook workbook = new Workbook("sample.xlsx");
// Access the first worksheet
Worksheet worksheet = workbook.Worksheets[0];
//Create BarStacked Chart
int i = worksheet.Charts.Add(ChartType.BarStacked, 5, 6, 20, 15);
// Retrieve the Chart object
Chart chart = worksheet.Charts[i];
// Set the chart title name 
chart.Title.Text = "Gantt Chart";
// Set the chart title is Visible
chart.Title.IsVisible = true;
// Set data range
chart.SetChartDataRange("B1:B6", true);
// Add series data range
chart.NSeries.Add("C2:C6", true);
// No fill for one serie
chart.NSeries[0].Area.FillFormat.FillType = FillType.None;
// Set the Horizontal(Category) Axis
chart.NSeries.CategoryData = "A2:A6";
// Reverse the Horizontal(Category) Axis
chart.CategoryAxis.IsPlotOrderReversed = true;
//Set the value axis's MinValue and MaxValue
chart.ValueAxis.MinValue = worksheet.Cells["B2"].Value;
chart.ValueAxis.MaxValue = worksheet.Cells["D6"].Value;
chart.PlotArea.Area.FillFormat.FillType = FillType.None;
//Show the DataLabels
chart.NSeries[1].DataLabels.ShowValue = true;
//Disable the Legend
chart.ShowLegend = false;
//Save the result
workbook.Save("result.xlsx");

You will get a file similar to result file.In the file, you will see the following: