We can add the data labels to the bars by selecting “Add Data Labels” using right-click.
Keep the “Series Overlap” at 100% and adjust the “Gap Width” to 10% under the “Plot Series On” section.Then, right-click and select “Format Data Series.” Trim the chart to make it look nicer by eliminating the white space between the bars. The chart may look like the one given below. (in this example, we have considered “Units” as 5) The units of date can adjust the scale as you want to see in the chart.In the panel, change the “Minimum” number under the “Bounds” options to the number you have noted.Click on the dates on the top of the chart and right-click, select “Format Axis.”.Note the number in the window under the “Number tab” and “General” categories.Right-click on the date given for the first task in a table and select “Format Cells.”.Remove the white space at the beginning of the chart. Now, the project timeline Excel Gantt chart is almost completed. In the “Format Data Series” panel, select “No Fill” under the “Fill” section and “No line” under the “Border” section.Click on the blue bar to select and right-click “Format Data Series.”.We need to make a blue bar invisible to show only the orange bars, which indicate the duration. When the categories are reversed, we may see the chart below. In a “Format Axis” panel, under the “Axis Options” section, check the “Categories in reverse order” box.We must select the axis data and right-click to select “Format Axis.”.But, the list of tasks shown in the chart is in reverse order. The above chart shows the list of tasks on the Y-axis and dates on the X-axis. In the “Axis Labels” range, select the list of tasks starting from “Task 1” to the end and click on “OK.”īelow is the output we can see after completing all the above steps.Click on “Edit” under the “Horizontal (Category) Axis Labels” on the right-hand side of the “Select Data Source” window.Then, press the “OK” button.Īgain, press the “Add” button to select the “Series name” and values of the “Duration” column the same as above.Īfter adding both the “Starting Date” and “Duration” data into the chart, Also, choose the list of dates in the “Series values” field. When the “Edit Series” pop-up appears, select the “Starting Date” label as the “Series name.” In this example, cell B1. Next, click on the “Add” button under “Legend Entries (Series).” “The “Select Data Source” window may appear to select the data.Select that empty area and right-click to choose the “Select Data” option. Next, choose the “Stacked” bar (the second option in the “2-D Bar“ section).īy selecting this graph, a blank chart area may appear. In the ribbon, go to the “INSERT” tab and select the “Bar graph” option in the “Charts” sub-tab. In the formula, “+1” is used to include the day of the starting date. The above table calculates duration using the formula: Ending Date (-) Starting Date. Note: We can insert duration directly or use a formula to determine duration. This column is optional because this is just for reference and will not be used in the chart. We can insert the “Ending Date” for the activities next to the “Duration” column.