How to Create a Gantt Chart

Sponsored Links :

How to Create a Gantt Chart ? This is a simple question that many people do not know the answer. If you have Primavera P6 Project Management Software or Microsoft Project, it will be easy. If you do not have them, that will be quite a problem. In this post, we will learn about How to Create a Gantt Chart. All you need is an microsoft excel software.

How to Create a Gantt Chart in Excel

  1. Copy the example worksheet data into a blank worksheet, or open the worksheet that contains the data that you want to plot into a Gantt chart.

Create a blank workbook or worksheet.
Select the example in the Help topic.
NOTE: Do not select the row or column headers.
Press CTRL+C.
In the worksheet, select cell A1, and press CTRL+V.

How to Create a Gantt Chart in Excel

NOTE: The values in columns B and C (Start and Duration) represent the number of days from the start date and the number of days required to complete the task.

  1. Select the data that you want to plot in the Gantt chart (A1:C6 in our example worksheet data).
  2. On the Insert tab, in the Charts group, click Bar.
  3. Under 2-D Bar, click Stacked Bar.
  4. Click the chart area of the chart.
  5. This displays the Chart Tools, adding the Design, Layout, and Format tabs.
  6. On the Design tab, in the Chart Styles group, click the chart style that you want to use.
  7. In the chart, click the first data series (Start), or select it from a list of chart elements (Format tab, Current Selection group, Chart Elements box).
  8. On the Format tab, in the Current Selection group, click Format Selection.
  9. Click Fill, and then click No fill.
  10. Click Close.
  11. In the chart, click the legend, and then press DELETE.
  12. Select the vertical (category) axis, or select it from a list of chart elements (Format tab, Current Selection group, Chart Elements box).
  13. On the Format tab, in the Current Selection group, click Format Selection.
  14. Under Axis Options, select the Categories in reverse order check box, and then click Close.
  15. If you want to use theme colors that are different from the default theme that is applied to your workbook, do the following:

On the Page Layout tab, in the Themes group, click Themes.
Under Built-in, click the theme that you want to use.

Sponsored Links :

TIP: For our Gantt chart, we used the Office theme.

Save a chart as a template

If you want to create another chart like the one that you just created, you can save the chart as a template that you can use as the basis for other similar charts.

  1. Click the chart that you want to save as a template.
  2. On the Design tab, in the Type group, click Save as Template.
  3. In the File name box, type a name for the template. 

TIP: Unless you specify a different folder, the template file (.crtx) will be saved in the Charts folder, and the template becomes available under Templates in both the Insert Chart dialog box (Insert tab, Charts group, Dialog Box Launcher Button image) and the Change Chart Type dialog box (Design tab, Type group, Change Chart Type).

For more information about how to apply a chart template, see Reuse a favorite chart by using a chart template.

NOTE: A chart template contains chart formatting and stores the colors that are in use when you save the chart as a template. When you use a chart template to create a chart in another workbook, the new chart uses the colors of the chart template — not the colors of the document theme that is currently applied to the workbook. To use the document theme colors instead of the chart template colors, right-click the chart area, and then click Reset to Match Style on the shortcut menu.

The tips How to Create a Gantt Chart in Excel above is presented by office[dot]com. Thanks to them who give a good contibution to make the GAntt Chart easier to make. Do not forget to use Original Microsoft Office Excel only.

We hope that the information above is useful. Please subscribe for more article related to Gantt Chart. Have a nice Browsing!

Leave a Reply