Select the range of data that represents your project tasks to add them to your Gantt chart.Ĭlick Finish at the bottom of the popup window. Navigate to the Category (X) Axis Labels section at the bottom of the popup window. Type in the appropriate name in the Name section, and select the appropriate values in the Values section of the window.Ĭontinue to add each series until all dates are plotted on your Gantt chart. Ideally, you should add a Start Date series, a Duration series, and an End Date series. In the next section of the popup window, select the Series tab at the top.Īdd the series information for each set of data that you wish to include in your Gantt chart. Within the popup window, select Bar from the left hand column, then select Stacked Bar from the options on the right. Go to the top navigation bar and select the Chart Wizard button on the menu ribbon. Select the data range that you want to make a Gantt chart for. Start by creating a date range in Excel that lists tasks, start date, and end date. To create a Gantt chart in Excel 20, follow the step-by-step instructions below: The steps to create a Gantt chart in Excel 20 are similar to the steps to create one in Excel 2007-current. You can also create a Gantt chart in earlier versions of Excel (20).

WorkApps Package your entire business program or project into a WorkApp in minutes.Digital asset management Manage and distribute assets, and see how they perform.Resource management Find the best project team and forecast resourcing needs.Intelligent workflows Automate business processes across systems.

Governance & administration Configure and manage global controls and settings.

Streamlined business apps Build easy-to-navigate business apps in minutes.Integrations Work smarter and more efficiently by sharing information across platforms.Secure request management Streamline requests, process ticketing, and more.Process management at scale Deliver consistent projects and processes at scale.Content management Organize, manage, and review content production.Workflow automation Quickly automate repetitive tasks and processes.Team collaboration Connect everyone on one collaborative platform.Smartsheet platform Learn how the Smartsheet platform for dynamic work offers a robust set of capabilities to empower everyone to manage projects, automate workflows, and rapidly build solutions at scale.

Gantt chart maker excel free