Then right-click and select “Format Axis” from the menu. Click a date in your Gantt chart to select all dates.Hit “Cancel” to close the box without making any changes.Under “Number” > “General,” you’ll see a number in a field called “Sample.” This number represents the date listed in your spreadsheet (Excel represents numbers based on the number of days since January 1, 1900).
To remove them and make better use of the space on your chart: Eliminate Empty Spaceĭepending on your first start date, your Gantt chart might have unused space along the left between your task names and your diagram. Then, you can make modifications to get it to look the way you want. Once you’ve got your basic Gantt chart uploaded to Excel, start by entering your project’s information into it. How To Edit a Gantt Chart Template in Excel Once you’ve updated it with your project data, you can make modifications to adjust the look and feel of the chart as well as add more complexities to your project. This is a basic template you can use to set up a Gantt chart for any project. If you want to skip a few steps, we created a simple Gantt chart Excel template you can download here:
