simulate a gantt chart

Upload: myforum1

Post on 06-Apr-2018

226 views

Category:

Documents


0 download

TRANSCRIPT

  • 8/3/2019 Simulate a Gantt Chart

    1/4

    Simulate a Gantt chart

    The following procedure will help you create a Gantt chart with results that are similar to those shown in our example

    Gantt chart graphic. For this chart, we used the example worksheet data. You can copy this data to your worksheet,

    or you can use your own data, as long as you use the same column headers and worksheet structure.

    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.

    How to copy the example worksheet data

    2. Create a blank workbook or worksheet.

    3. Select the example in the Help topic.

    4. Press CTRL+C.

    5. In the worksheet, select cell A1, and press CTRL+V.

    1

    2

    3

    4

    5

    6

    A B C

    Task Start Duration

    Task 1 0 2

    Task 2 2 6

    Task 3 8 9

    Task 4 17 3

    Task 5 20 5

    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.

    6. Select the data that you want to plot in the Gantt chart (A1:C6 in our example worksheet data).

    7. On the Insert tab, in the Charts group, click Bar.

    8. Under2-D Bar, click Stacked Bar.

    9. Click the chart areaof the chart.

    This displays the Chart Tools, adding the Design, Layout, and Format tabs.

    10. On the Design tab, in the Chart Styles group, click the chart style that you want to use.

    http://togglediv%28%27divexpcollasst_766552633%27%29/http://appendpopup%28this%2C%2717711244_1%27%29/http://appendpopup%28this%2C%2717711244_1%27%29/http://appendpopup%28this%2C%2717711244_1%27%29/http://togglediv%28%27divexpcollasst_766552633%27%29/
  • 8/3/2019 Simulate a Gantt Chart

    2/4

    TIP For our Gantt chart, we used Style 27.

    11. 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).

    12. On the Format tab, in the Current Selection group, click Format Selection.

    13. Click Fill, and then click No fill.

    14. Click Close.

    15. In the chart, click the legend, and then press DELETE.

    16. Select the vertical (category) axis, or select it from a list of chart elements (Format tab, Current Selection

    group, Chart Elements box).

    17. On the Format tab, in the Current Selection group, click Format Selection.

    18. UnderAxis Options, select the Categories in reverse ordercheck box, and then click Close.

    19. If you want to use theme colors that are different from the default theme that is applied to your workbook, do

    the following:

    1. On the Page Layout tab, in the Themes group, click Themes.

    2. UnderBuilt-in, click the theme that you want to use.

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

    TOP OF PAGE

    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.

    20. Click the chart that you want to save as a template.

    http://office.microsoft.com/client/helppreview.aspx?AssetId=HA102382539990&lcid=1033&NS=EXCEL&Version=12&respos=0&CTT=1&queryid=fd8a22cb-77e6-42ef-aa41-c1911d55ca58#tophttp://office.microsoft.com/client/helppreview.aspx?AssetId=HA102382539990&lcid=1033&NS=EXCEL&Version=12&respos=0&CTT=1&queryid=fd8a22cb%2D77e6%2D42ef%2Daa41%2Dc1911d55ca58#tophttp://office.microsoft.com/client/helppreview.aspx?AssetId=HA102382539990&lcid=1033&NS=EXCEL&Version=12&respos=0&CTT=1&queryid=fd8a22cb-77e6-42ef-aa41-c1911d55ca58#top
  • 8/3/2019 Simulate a Gantt Chart

    3/4

    21. On the Design tab, in the Type group, click Save as Template.

    22. 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 underTemplates in both the Insert Chart dialog box (Insert tab, Charts

    group, Dialog Box Launcher ) 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.

    TOP OF PAGE

    See Also

    Change the format of chart elements

    Change the layout or style of a chart

    Create a chart

    How to create a Gantt chart that uses hours as the scale in Excel 2007

    Present your data in a bar chart

    Print a chart

    Let Project Map take your job from start to finish

    http://office.microsoft.com/client/helppreview.aspx?AssetId=HA100072059990&lcid=1033&NS=EXCEL&Version=12&CTT=5&origin=HA010238253http://office.microsoft.com/client/helppreview.aspx?AssetId=HA100072059990&lcid=1033&NS=EXCEL&Version=12&CTT=5&origin=HA010238253http://appendpopup%28this%2C%2752832280_2%27%29/http://appendpopup%28this%2C%2752832280_2%27%29/http://office.microsoft.com/client/helppreview.aspx?AssetId=HA102382539990&lcid=1033&NS=EXCEL&Version=12&respos=0&CTT=1&queryid=fd8a22cb-77e6-42ef-aa41-c1911d55ca58#tophttp://office.microsoft.com/client/helppreview.aspx?AssetId=HA101534479990&lcid=1033&NS=EXCEL&Version=12&CTT=3http://office.microsoft.com/client/helppreview.aspx?AssetId=HA012341699990&lcid=1033&NS=EXCEL&Version=12&CTT=3http://office.microsoft.com/client/helppreview.aspx?AssetId=HP012337289990&lcid=1033&NS=EXCEL&Version=12&CTT=3http://office.microsoft.com/redir/XT102383199990.aspx?client=1&Ver=12&NS=EXCEL&lc=en-US&CTT=3http://office.microsoft.com/client/helppreview.aspx?AssetId=HA102186649990&lcid=1033&NS=EXCEL&Version=12&CTT=3http://office.microsoft.com/client/helppreview.aspx?AssetId=HP012337559990&lcid=1033&NS=EXCEL&Version=12&CTT=3http://office.microsoft.com/client/helppreview.aspx?AssetId=HA102143779990&lcid=1033&NS=EXCEL&Version=12&CTT=3http://office.microsoft.com/client/helppreview.aspx?AssetId=HA102382539990&lcid=1033&NS=EXCEL&Version=12&respos=0&CTT=1&queryid=fd8a22cb%2D77e6%2D42ef%2Daa41%2Dc1911d55ca58#tophttp://office.microsoft.com/client/helppreview.aspx?AssetId=HA100072059990&lcid=1033&NS=EXCEL&Version=12&CTT=5&origin=HA010238253http://office.microsoft.com/client/helppreview.aspx?AssetId=HA100072059990&lcid=1033&NS=EXCEL&Version=12&CTT=5&origin=HA010238253http://appendpopup%28this%2C%2752832280_2%27%29/http://office.microsoft.com/client/helppreview.aspx?AssetId=HA102382539990&lcid=1033&NS=EXCEL&Version=12&respos=0&CTT=1&queryid=fd8a22cb-77e6-42ef-aa41-c1911d55ca58#tophttp://office.microsoft.com/client/helppreview.aspx?AssetId=HA101534479990&lcid=1033&NS=EXCEL&Version=12&CTT=3http://office.microsoft.com/client/helppreview.aspx?AssetId=HA012341699990&lcid=1033&NS=EXCEL&Version=12&CTT=3http://office.microsoft.com/client/helppreview.aspx?AssetId=HP012337289990&lcid=1033&NS=EXCEL&Version=12&CTT=3http://office.microsoft.com/redir/XT102383199990.aspx?client=1&Ver=12&NS=EXCEL&lc=en-US&CTT=3http://office.microsoft.com/client/helppreview.aspx?AssetId=HA102186649990&lcid=1033&NS=EXCEL&Version=12&CTT=3http://office.microsoft.com/client/helppreview.aspx?AssetId=HP012337559990&lcid=1033&NS=EXCEL&Version=12&CTT=3http://office.microsoft.com/client/helppreview.aspx?AssetId=HA102143779990&lcid=1033&NS=EXCEL&Version=12&CTT=3
  • 8/3/2019 Simulate a Gantt Chart

    4/4