1/21/2021 Create a Gantt Chart in Excel - Easy Excel Tutorial
Excel Easy
#1 Excel tutorial on the net Excel Introduction Basics Functions Data Analysis VBA 300 Examples Ask us
Gantt Chart Search Entire Site Go
Excel does not offer Gantt as chart type, but it's easy to create a Gantt chart by customizing the
Chapter
stacked bar chart type. Below you can find our Gantt chart data.
Charts
Learn more, it's easy
Column Chart
Line Chart
Pie Chart
Bar Chart
Area Chart
Scatter Plot
Data Series
To create a Gantt chart, execute the following steps.
Axes
Chart Sheet
Trendline
Error Bars
Sparklines
Combination Chart
Gauge Chart
Thermometer Chart
Gantt Chart
1. Select the range A3:C11.
Pareto Chart
2. On the Insert tab, in the Charts group, click the Column symbol.
Download Excel File
[Link]
Follow Excel Easy
3. Click Stacked Bar.
Become an Excel Pro
[Link] 1/5
1/21/2021 Create a Gantt Chart in Excel - Easy Excel Tutorial
300 Examples
Result:
4. Enter a title by clicking on Chart Title. For example, Build a House.
5. Click the legend at the bottom and press Delete.
Succeed online.
Bring your idea to life
online with our 24/7 help.
6. The tasks (Foundation, Walls, etc.) are in reverse order. Right click the tasks on the chart, click
Format Axis and check 'Categories in reverse order'.
[Link] 2/5
1/21/2021 Create a Gantt Chart in Excel - Easy Excel Tutorial
Result:
7. Right click the blue bars, click Format Data Series, Fill & Line icon, Fill, No fill.
[Link] 3/5
1/21/2021 Create a Gantt Chart in Excel - Easy Excel Tutorial
8. Dates and times are stored as numbers in Excel and count the number of days since January 0,
1900. 1-jun-2017 (start) is the same as 42887. 15-jul-2017 (end) is the same as 42931. Right click
the dates on the chart, click Format Axis and fix the minimum bound to 42887, maximum bound
to 42931 and Major unit to 7.
Result. A Gantt chart in Excel.
Note that the plumbing and electrical work can be executed simultaneously.
17/18 Completed! Learn much more about charts >
Go to Next Chapter: Pivot Tables
[Link] 4/5
1/21/2021 Create a Gantt Chart in Excel - Easy Excel Tutorial
Gantt Chart • © 2010-2021
Excel is Awesome, we'll show you: Introduction • Basics • Functions • Data Analysis • VBA
[Link] 5/5
