This will reverse the order of the Gantt chart, so it shows the first tasks at the beginning and the last tasks at the end. In the popup window, select the Scale tab and check the box that says Categories in Reverse Order. Next, right click on the vertical axis that shows tasks and select Format Axis. In the popup window under the Patterns tab, change both the border and the area options to None to hide the first set of bars. Right click on the first set of bars and click Format Data Series. Next, hide the first set of bars by changing their color. Right click on the vertical axis and select Format Axis. To clean up your Gantt chart axes, right click on the horizontal axis and select Format Axis.Ĭlick on the Font tab at the top of the popup window, and set the font size to 10.Ĭlick OK when you have finished to exit out of the popup window. 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.