Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to use Excel ROWS Function
  • Approximate match with multiple criteria in Excel
  • Merge tables with VLOOKUP in Excel
  • Lookup entire row in Excel
  • Multi-criteria lookup and transpose in Excel

Data Analysis Examples

  • Managing Conditional Formatting Rules in Excel
  • How To Compare Two Lists in Excel
  • Everything about Charts in Excel
  • How to create Checklist in Excel
  • Calculate Conditional Percentile ‘IF’ in table in Excel

Data Validation Examples

  • Excel Data validation must begin with
  • Excel Data validation exists in list
  • Excel Data validation require unique number
  • Excel Data validation date in specific year
  • Excel Data validation unique values only

How to Create Gantt Chart in Excel

by

Illustrate Project Schedule in Gantt Chart

Excel does not offer Gantt as chart type, but it’s easy to create a Gantt chart by customizing the stacked bar chart type.

Below you can find our Gantt chart data.

To create a Gantt chart, execute the following steps.

1. Select the range A3:C11.

2. On the Insert tab, in the Charts group, click the Column symbol.

3. Click Stacked Bar.

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.

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’.

Result:

7. Right click the blue bars, click Format Data Series, Fill & Line icon, Fill, No fill.

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.

Post navigation

Previous Post:

Wrap Text Automatically vs Manual Line Break in Excel

Next Post:

How to change Excel Workbook Themes

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • Join cells with comma in Excel
  • Join Text Strings Using Concatenate or ‘& Operator’ in Excel
  • How to pad text to match equal length in Excel
  • How to extract text between parentheses in Excel
  • How to count total words in a cell in Excel
  • DATEDIF function: Description, Usage, Syntax, Examples and Explanation
  • EDATE function: Description, Usage, Syntax, Examples and Explanation
  • Calculate series of dates by workdays in Excel
  • Convert Unix time stamp to Excel date
  • Convert text date dd/mm/yy to mm/dd/yy in Excel
  • RRI function: Description, Usage, Syntax, Examples and Explanation
  • ODDLPRICE function: Description, Usage, Syntax, Examples and Explanation
  • DISC function: Description, Usage, Syntax, Examples and Explanation
  • DOLLARFR function: Description, Usage, Syntax, Examples and Explanation
  • RATE function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles