Floating bar charts, or Gantt diagrams, are fixtures in the world of project management. They are a visual representation of the start and finish dates of all of the various elements of a project throughout its life cycle. They are not a specific feature of Microsoft Excel's Chart Wizard. However, it is possible to simulate a Gantt diagram by graphing two series of dependent data in a stacked bar chart. (See Reference 1)
- Skill level:
- Moderately Easy
Other People Are Reading
Create a new worksheet and label the first three column headings "Task," "Start," and "Duration." (See Reference 1)
Enter the various tasks of the project in the first column, their respective start dates in the second column, and the amount of days allotted to each task in the third column.
Click on any cell in the "Start" column and click on the "Sort Descending" button in the toolbar to sort the entire data set in reverse order by start date.
Select all three data sets by clicking and dragging your mouse across the entire range of cells. Be sure to include the column headers.
Click on the Chart Wizard button in the toolbar. Select a "Floating Bars" or "Stacked Bars" chart type, depending on your version of Excel. Confirm that it appears the way you want it to in your preview window and click "Finish." You now have a floating bar chart denoting your project timeline.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for