![gantt chart excel gantt chart excel](http://img.chandoo.org/pm/quick-gantt-chart-template-excel.png)
Gantt chart Excel is the best management tool provided by excel that highlights the project plan very effectively. Monitor the chart on a regular basis so that you can monitor the progress.As soon as you entered the data, you can make your chart more presentable and clear.Now convert the bar chart into a Gantt chart.Now if you have divided your work into subtasks, make a column under the task title for adding the information about the subtasks with their milestone and title.A bar chart can be added for the duration of tasks as well.The date range selects from the column and insert the select data in the bar chart.Create a spreadsheet including the headings such as the title of the task, starting and end dates, and current status of each task.Multiple Project Portfolio Dashboard Excel Template.Here are some steps that describe the Gantt chart excel template with subtasks with the best way This template is mainly used for complex projects by converting the timeline and tasks in the horizontal bar chart, indicating how much task has been completed, it helps the manager in keeping the tasks on track so that the work may finish in time. It also enables managers to manage their work efficiently without any trouble. It is helpful as it gives an effective schedule for your project. The graph is plotted in the form of a bar chart. Gantt chart provides a graphical representation of the project. Gantt chart will be designed according to data.This article helps you understand the Gantt chart template in the best way. You can also change the format of the date by right click on date/format axis/number and select format of date. Now you can found little bit easy readable data in the chart. starting and ending date of the project in a comma style. Right click on dates which are appeared on the chart, select format axis and enter minimum fixed and maximum fixed value i.e. Enter your starting date and ending date of your project and convert it into comma style. For the better view of chart, we have to change dates into the comma style (Display the value of a cell with a thousand separators). In a chart you can found all the tasks and also found Tasks4 and Tasks5 overlap each other. You can found the entire tasks in a specific order. There are a Labels Tasks1, Tasks2….Task8 now format them by right clicking on it and choose option “Categories in reverse Order” and close.Now you can found some appearance of the Gantt chart. There are options Fill for that select no fill, For Border Colour select no colour and click on close button.
![gantt chart excel gantt chart excel](https://www.allbusinesstemplates.com/thumbs/997f62bc-e4d5-4474-bc9b-a1f1d2fa4b7f_1.png)
#Gantt chart excel series
In the series you found the Blue Bars.Select them both and delete them because for the Gantt chart there is no need of the legends. There are two legends named Start Date and Duration.Click OK and you will see that under the Axis label name of the entire task are labelled. For changing the Axis Labels, click on edit and fill the axis label range by selecting the all the tasks (Task1, Task2….Taks8) under labelled Tasks.Repeat the same operation with the column labelled Duration.
![gantt chart excel gantt chart excel](https://www.officetooltips.com/images/tips/278_365/1.png)
Click on the series values and select all the dates of the column start date in Excel sheet and click OK. Click on the series name and select the label name, start date in excel sheet.By clicking on add, edit series dialog box will be appeared with series name and series values.In this dialog box click on add the series. Select data source dialog box will appear. For selecting data for the stacked bar chart, right click on the chart and clicked on the select data option.
![gantt chart excel gantt chart excel](https://www.professionalexcel.com/wp-content/uploads/2011/06/Project-Manager-Gantt-Chart-1.0-screenshot.jpg)
Select a Stacked Bar Chart using Chart Wizard.