Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Conditional Formatting Color Scales Examples in Excel
  • How To Load Analysis ToolPak in Excel
  • Use Data Form to input, edit and delete records in Excel
  • Add Outline to Data in Excel
  • How to count table rows in Excel

References

  • Vlookup Examples in Excel
  • How to get last row in text data in Excel
  • Find closest match in Excel
  • How to reference named range different sheet in Excel
  • Basic INDEX MATCH approximate in Excel

Data Validations

  • Excel Data validation with conditional list
  • Excel Data validation must contain specific text
  • Excel Data validation only dates between
  • Excel Data validation require unique number
  • Excel Data validation whole percentage 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:

Excel Data validation with conditional list

Next Post:

Excel Data validation require unique number

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

Logical Functions

  • SWITCH function example in Excel
  • IF, AND, OR and NOT Functions Examples in Excel
  • How to return blank in place of #DIV/0! error in Excel
  • How to use Excel NOT Function
  • Invoice status with nested if in Excel

Date Time

  • Get days, months, and years between dates in Excel
  • EOMONTH function: Description, Usage, Syntax, Examples and Explanation
  • Get fiscal year from date in Excel
  • Next biweekly payday from date in Excel
  • Count holidays between two dates in Excel

Grouping

  • Categorize text with keywords in Excel
  • How to randomly assign people to groups in Excel
  • If cell contains one of many things in Excel
  • Group numbers at uneven intervals in Excel
  • Group numbers with VLOOKUP in Excel

General

  • Excel Autofill Cell Ranges, Copy, Paste
  • How to get Excel workbook path only
  • Currency vs Accounting Format in Excel
  • How to get random value from list or table in Excel
  • How to calculate project complete percentage in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning