Monday, November 18, 2013

How to Make a PERT Chart in Excel


1. Launch Microsoft Excel 2010.
2. Click 'Insert' at the top of the window.
3. Click the 'Shapes' drop-down menu in the Illustrations section of the ribbon. Select your desired shape from the Flowchart section.
4. Click your mouse at the location in the spreadsheet where you wish to insert the object, and then drag the mouse until the outline of the shape is the desired size.
5. Click the 'Text Box' option in the Insert Shapes section of the ribbon. Click inside the shape you just created and use your mouse to draw a text box inside the shape. Note that you can also click a color for the shape from the Shape Styles section of the ribbon.
6. Type the necessary text for the object.
7. Insert additional shapes from the Shapes drop-down menu on the Insert tab, and then add text boxes to each shape as needed.
8. Click your desired connector arrow from the Insert Shapes section of the ribbon.
9. Click the shape that will serve as the anchor for the arrow, and then drag the arrow to the target shape for the arrow.
10. Add additional arrows to your chart as needed.
11. Add outlying text to your chart by clicking the 'Insert' tab at the top of the window and then clicking the 'Text Box' button in the Text section of the ribbon.
12. Click in the desired location on your spreadsheet for the text box, and then drag the mouse until your desired text box shape is displayed.
13. Type your text into the text box.
14. Add additional text boxes to your chart until the chart is complete.

Blogger news