And you might be wondering how to make a Gantt chart for your company’s projects, right? Well, here we have prepared a step-by-step guide for you to do it in Excel.
1. Create a task table
List each task in your project in order from taiwan telegram data start to finish. Include the task name, start date, duration, and end date.
Make your list as comprehensive as possible. Due to limitations in Office spreadsheets , adding steps or zooming may force you to format the entire chart.
2. Create a bar graph
From the top menu, select “insert” and then curious missteps in b2b email marketing click on the bar chart icon. When the drop-down menu appears, choose the flat stacked bar chart highlighted in green below. This will insert a blank chart into your spreadsheet.
3. Add start date data
Place your mouse over the empty Excel phone number vietnam chart and right-click. Then left-click on “select data”. The “select source” data window will appear.
First click on the empty series name in the form field, then click on the table cell that says “Start Date.”
Click on the icon at the end of the series “values” field. The icon is a small spreadsheet with a red arrow. This will open the “edit series” window.
Click on the first start date and drag the mouse to the last start date. After highlighting the correct dates, click on the icon at the bottom of the “edit series” form.
The window will close and the previous window will reopen. Select OK. Your start dates are now in the Gantt chart.
Then add the “durations” column using the same procedure as for adding start dates.
Under “Subtitle Entries,” click “Add.” Click the empty series name, then the form field, then the table cell that says “duration.”
Once the durations are highlighted, click the icon at the bottom of the “edit series” form. The window will close and the previous window will reopen. Select OK. Your durations are now in your Gantt chart. Click OK twice.
4. Format your Gantt chart
What you have now is a stacked bar chart. The start dates are blue and the durations are orange.
Please note that your tasks are in reverse order. To fix this, click on the task list to select it, then right-click on the list and choose “format axis”. Select the “categories in reverse order” checkbox and close.
To make more space on the Gantt chart, delete the heading “start date”, duration on the right. Select it with the mouse and click delete.
Hide the blue parts of each bar. Clicking on the blue part of any bar will select all of them. Then right click and choose “format data series”.
Click Fill and select “no fill.” Click the border color and select “no line.” Then you just need to remove the empty white space at the beginning of your Gantt chart.
Click on the first start date in your data table. Right-click on it, select “format cells” and then “general.” Type in the number you see. Click “cancel” to make no changes here.
In the Gantt chart, select the dates above the bars, right-click and choose “format axis.”
Change the lower limit to the number you recorded. Change the main unit to 2, every other day. You can play around with this to see what works best for you.
Select “close”.
If you want your Gantt chart to look a little nicer, remove most of the white space between the bars.
Finally, click on the top orange bar and right-click on “format data series.” Set the selected field to 100% and the range width to 10%.